cpu usage high by Sqlserver? how to become normal??
HI I am a Junior DBA we are using SQL Server 2005, In our Server 32 GB of RAM CPU Processor EM64T Family 6 model 15 stepping 6 Genuineintel-1995 mhz windows server 2003 R2 **But last week we faced CPU usage very high by SQL SERVER.** see the figure below; Fig 1: ![alt text] Fig 2: ![alt text] I have checked for any long running queries/Transaction checked in day by day basis. but recently no long running quries are taken place then **why CPU process reaches 100% frequently? which steps to follow CPU become normal state or not using SQL SERVER more resource???** : /storage/temp/509-sql+process+high.jpg : /storage/temp/510-cpu+usage+high.jpg
You should capture the counters to find what makes your CPU spikes high. It could be because of memory or disk bottleneck or it could be because of Aggregates, sort or string manipulation in your queries. These are basic reasons, there are plenty of other reasons also. So better start running a performance trace by using SQL Server Profiler trace and Windows performance monitor, Start capturing the basic counters in Windows Monitor, and the query and the query stats in profiler, correlate the result of perfmon and the profiler, these shows what in SQL Server made these spikes go high. I advice you to no to capture these info in your production.