>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.
If it's not broken, fix it until it is.
My Blog