Posted by blueghost73@yahoo.com on 07/26/06 21:41

Isam wrote:
> 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.

Oddly, the first rule of computer trouble shooting would seem to apply
here: When in doubt, turn off the Microsoft product. :P

Seriously, does this happen even after restarting SQL and/or the
server?

That's about it for me. I don't know enough to really trouble shoot
this, but I can point out the obvious with the best of them. ;)

--Richard

[Back to original message]