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.
|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.