High CPU Usage

xexexxexex Posts: 56
edited February 3, 2012 10:01AM in SQL Monitor Previous Versions
A Processor utilization alert has been obtained in SQL monitor, the CPU usage is 100% over 15 mins, and there are many Long running query alerts which cuased by "Process name: SQL Monitor - Monitoring".

Did SQL monitor caused the high CPU usage? if no, how can I found which query cuased in SQL monitor?
· Share on Twitter

Comments

  • xexexxexex Posts: 56
    Problem found.
    A programmer said that he inserted 500K records before.........

    However, can I found which query using SQL Monitor?
    · Share on Twitter
  • Eddie DEddie D Posts: 1,808 Rose Gold 5
    Thank you for your posts into the forum and excellent news that you identified the cause of your high CPU usage.

    Was SQL Monitor able to generate a Long Running Query alert for the query running the insert statement? If the answer was yes, was the information in the alert helpful to you?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.