Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange SQL Server 2008 CPU usage
Message
 
 
À
06/01/2010 15:06:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01442412
Message ID:
01443205
Vues:
57
>>>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...

See also somewhat related thread http://forums.asp.net/p/1511195/3609683.aspx#3609683
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform