Question Locked

suddenly SQLSERVR.EXE CPU Usage showing up to 60%

0 helpful

2 replies

by theunique1011 Oct 21, 2009 last reply Oct 21, 2009

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 CPU Usage showing up 60%. what are the causes how to find those? and how to decrease CPU Usage.
please someone help me

2 replies

Clarifications

How in Cthulus name can we tell you what you sever running your code with your data is doing?

When does it go to 60%, for how long and what command(s) is it running that the time?

This discussion is closed to new replies.