CPU Usage...
-
My CPU Usage has been running at about 60 - 80% all day. In Task Manager, it shows that the sqlserver.exe process is reading 60-70 in the CPU column. None of my other servers are doing this. Can anyone help me???
-
You might try reading this article on using the sysprocesses table... I've found it helpful tracking down rogue Crystal reports that users have been running against our production db:
http://www.sqlservercentral.com/columnists/tTroisi/detectingperformanceissueswithsysprocesses.asp
Good luck!
Brian
-
It might be just the expected load on that hardware with that number of users. Or it could be something you can reduce.
60-80% is less than 100%, which is where you have problems.
-
All, I found out what it was. I had a Maintenance Plan that didn't complete a backup that morning and the file was corrupted. Somehow when the MP didn;t function correctly, it left a sqlserver.exe process, with a user of SYSTEM, hanging on the box. This was the process that was eating up all of the CPU. This morning when the scheduled MP completed successfully, the process was released. Weird, huh?!?! I've never run into this before.
Thanks for all your help! -
Can you please post how you found this solution. Was it through querying the sysprocesses table?
-
I actually read it in another forum. There was another DBA out there who apparently ran into the same issue. I looked in Task Manager on the server and there were two instances of sqlserver.exe running. One had a user of SYSTEM (the culprit), and one had a user of <my login>.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply