Toad World® Forums

Sql-Server high CPU utilization


#1

For last three or four weeks we are receiving alerts from Spotlight for Sql-Server Enterprise regarding high CPU utilization on ONE of you production servers.

Before this weeks we only have 1 alert at 7 am.

Now we have two, three or more alerts a day, can you help me how can I trace and relate CPU activite with process or querys ?

Thank you


#2

Have you used the Playback feature to the point in time of the alert? Depending on how much history you store, you should be able to go back to when that alert was fired and see what was going on at that time.


#3

Yes, in fact I was able to see the problem in real time.