Long Running Query Alert

Category: sql server notification


Aadhira on Fri, 28 Aug 2015 11:02:39

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.


HoroChan on Mon, 31 Aug 2015 05:00:53

What is the query to determin the email context? maybe you could add a where condition to exclude the sp_server_diagnostics.