cpu high
-
hello experts,
in my server generally cpu is 10 to 20 but now it is going upto 40 to 80 how can i find the prob? and which process is main cause of it pls help
-
Use SQL Server DashBoard to find out more expensive qrys in terms of CPU.... can run execution plan against those qrys...
Also check Processor counters by using perfmon.... check the settings for MDOP....
-
check the performance monitor....chk the process which is causing high memory consumption...
Raunak J
-
hi sumit, can u tell me, how can i find more expensive query in terms of cpu ?
and also i seteed up (MAXDOP 5) for on of my search query becose of parallalism problem? how to decide MAXDOP can u tell??
-
Right Click on server name --> Reports --> Standard Reports --> Performance - Top Qrys by CPU...
Also go thru below links....
http://support.microsoft.com/kb/329204
http://blog.sqlauthority.com/2010/03/15/sql-server-maxdop-settings-to-limit-query-to-run-on-specific-cpu/ -- by pinal dave...
I hope this would be helpful...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply