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 9: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 9:04 am

Postby chriskelly » Mon Jan 13, 2014 11:38 am

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.
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests