Networks

Ask something
Question Locked

suddenly SQLSERVR.EXE CPU Using 100% CPU

0 helpful
2 replies

by shireenreddy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Environment
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

2 replies

by tony hopkinson

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.

This discussion is closed to new replies.