Exclude BACKUP DATABASE from Alert "Long Running Query"

Monitor, diagnose and receive alerts to problems across your SQL Servers.

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"?
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
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests