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?
xexex
0

Comments

2 comments

  • xexex
    Problem found.
    A programmer said that he inserted 500K records before.........

    However, can I found which query using SQL Monitor?
    xexex
    0
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.