suddenly SQLSERVR.EXE CPU Using 100% CPU

By shireenreddy ·
SQL Server 2005 enterprise Edition with sp2
Windows server 2003 with sp2

suddenly SQLSERVR.EXE using 100% CPU. no new changes has been made. no new jobs or stored procedures added. what are the causes how to find those? and how to decrease CPU Usage.
please someone help me

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Well if nothing else has changed

by Tony Hopkinson In reply to suddenly SQLSERVR.EXE CPU ...

then it can only be usage pattern. So you need have a look at the activity.

SQL Server Management studio on the Management node of the tree.

With winders nothing has changed needs to be like really nothing. e.g no windows updates, no changes to linked servers, the network they are on, possibly even the clients.

For instance you haven't got some MBA type connecting up Access or Excel to your DB and running 'erm less than well thought out queries.

No way to say from here. Check for abnormal stuff. Windows event log, sql server logs, the activity monitor, DBCC Checkdb etc.

Related Discussions

Related Forums