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.