Stop notification

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Stop notification

Postby DBdave » Fri Aug 15, 2014 4:52 pm

How can stop this Long Query Notification notification!!!

Process ID: 62
Process name: Microsoft SQL Server Management Studio
Database: XXXXXX
Process login time: 15 Aug 2014 4:15 PM
Query start time: 15 Aug 2014 4:15 PM
Query duration: 4.9540001 sec
SQL process fragment
Command Type: BACKUP LOG

I have added this into my Alert Settings configuration for long running queries:

Exclude queries with a SQL process name matching the following regular expressions:

Exclude queries that contain SQL commands or objects matching the following regular expressions:

Posts: 8
Joined: Thu Oct 03, 2013 11:21 am

Postby chriskelly » Mon Aug 18, 2014 2:16 pm

My guess is that the regular expression you are specifying is not matching the BACKUP LOG in the SQL Process fragment.

Possibly consider using:
(assuming that the SQL Process will always be in capitals and it is all backup log jobs you want to ignore).
(/s is the escaped character for 'space')

It may take some trial and error to get exactly the behaviour you are looking for. may also help:
Chris Kelly
Technical Support Engineer
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests