Exclude BACKUP DATABASE from Alert "Long Running Query"

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Exclude BACKUP DATABASE from Alert "Long Running Query"

Postby netordead » Fri Jan 10, 2014 10:09 am

The query of the maintainance plan for backing up the DB always takes some but thats expected. Is there any chance I can exclude this query from the alert "Long Running Query"?
netordead
 
Posts: 1
Joined: Fri Jan 10, 2014 10:04 am

Postby chriskelly » Mon Jan 13, 2014 12:38 pm

In the Alert configuration for the Long-Running Query alert, there are two fields which can be used to specify the exclusion of processes. These use regular expressions and the tooltip ('?') explains in more detail how to use it.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests