High CPU Utlization at times

[bmeche]

I have a customer that is having a problem with there software timing out. When the timeouts occur the SQL seems to be taking up a lot of CPU Time, it seems that it is performing some sort of function or something that it is having problems with. Once the CPU Resources drop down to a normal rate the software seems to function fine.

Is there a log file or something that I can look at to see what is happening at that time, or is there another way to monitor the SQL Server

Bret

 

[JayKusch]

Your can run performance monitor on the server and set, maybe a "duration counter" to see what may be running and consuming the resources. There are various other meterics you could also look at.

Another option is to get into Enterprise Manager and check out the "Process Info" tab when the slow down occurs. Maybe you will see a SPID that is running a stored procedure or maybe a job is running during this time.

As mentioned, look to see if any scheduled jobs are running during this lag. Once again, this is found in Enterprise Manager under Management..SQL Server Agent..Jobs

These are good starting points.

Thanks

J. Kusch

 

[Kressmark]

Hi,

Using SQL Profiler you can trace all incoming traffic to SQL server, it will also list the duration (time) of individual queries.

/mk

 

[Corran007]

is autoshrink on? or a really small autogrow incriment? those are in the database properties. ive seen a server come to its knees when shrinking. autogrow can also be quite expensive performance wise.