Posted by Isam on 07/26/06 17:11

Hello,

Any help is greatly appreciated.


I've recently upgraded my MSDE 2000 to SQL Server 2005 Express Edition
on my Windows 2003 server SP1. I've noticted that running a single one

table query against the new sql engine causes the sqlservr.exe process
to consume 98% of CPU on the server. The spike usually lasts for a
20-30 seconds and I can't figure out why. The query is a simple select

query against one table with only 3000 records.


The server is a one proc machine 2.0 GHz celeron, with 1 GB of RAM.


Again, any suggestions are appreciated.


Thank you.

[Back to original message]