Red Gate forums :: View topic - Stop notification
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Stop notification

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DBdave



Joined: 03 Oct 2013
Posts: 8

PostPosted: Fri Aug 15, 2014 4:52 pm    Post subject: Stop notification Reply with quote

How can stop this Long Query Notification notification!!!

Process ID: 62
Process name: Microsoft SQL Server Management Studio
Database: XXXXXX
Host: XXXXXXXXX
User: XXXXXXX
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:
[Bb]ackup|BACKUP LOG|BACKUP

Exclude queries that contain SQL commands or objects matching the following regular expressions:
[Bb]ackup|BACKUP LOG|BACKUP

Thanks
D
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Mon Aug 18, 2014 2:16 pm    Post subject: Reply with quote

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

Possibly consider using:
BACKUP/sLOG
(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.

RegExLib.com may also help:
http://regexlib.com/CheatSheet.aspx
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group