Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL Server 2008 CPU usage
Message
From
06/01/2010 15:06:46
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01442412
Message ID:
01442479
Views:
47
>>I have noticed that my SQL Server 2008 (Express) uses CPU cycles when nothing is happening on the database. At first I thought it was doing some housekeeping with idle CPU time -- it was using anywhere from 2% to 35% of the CPU (with usage increasing the longer the system was otherwise idle.) So, I paused the SQL server and the various services (reporting, browsing, etc.) It was STILL chewing up CPU. This goes on until I stop the service alltogether -- that's when CPU usage finally returns to zero.
>>
>>This is pretty annoying, because even at 2% usage my system becomes sluggish (must be some serious I/O going on in the background?)
>>
>>The server is installed on my desktop machine (dual core AMD with 4 GB of memory.)
>>
>>Any ideas?
>
>Try asking here http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads - you have better chance of getting expert's advice.

Thanks! Will do...
Pertti Karjalainen
Product Manager
Northern Lights Software
Fairfax, CA USA
www.northernlightssoftware.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform