Long Running Query Alert

I have a Long running query alert. It sent me an alert when a query runs more than 10sec. My SQL server is in Alwayson Availability group.

My problem is the Long running query alert sent an alert mail for every 10 sec. See below.

Session_id Duration(sec) Status CurrentQuery CompleteQuery ProgramName Hostname isblocked
53 11417 suspended sp_server_diagnostics sp_server_diagnostics Microsoft Windows Operating System DB01 0

I need to block sp_server_diagnostics in my alert. Anyone help me to fix this.

August 28th, 2015 11:02am

What is the query to determin the email context? maybe you could add a where condition to exclude the sp_server_diagnostics.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 1:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics