Red Gate forums :: View topic - Want to stop notifications for Long Running Queries
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

Want to stop notifications for Long Running Queries

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



Joined: 23 Nov 2009
Posts: 5

PostPosted: Thu Jan 23, 2014 6:55 pm    Post subject: Want to stop notifications for Long Running Queries Reply with quote

Hello,

I recently installed SQL Mon 4, never used any prior version. I also use RG's SQL Backup and everytime it runs SM4 sends me alerts on long running queries which I want to stop. What do I need to put into the exclude box(es) to make this work so SQL Server backup and/or Red Gate SQL Backup does not trigger this alert? I tried the following in the top box and it doesn't work:

[Bb]ackup
SQLAgent

Thank you.
Back to top
View user's profile Send private message
Colin Millerchip



Joined: 31 Oct 2007
Posts: 62
Location: Cambridge, UK

PostPosted: Thu Jan 23, 2014 10:18 pm    Post subject: Reply with quote

Hi,

I'm pretty sure the name of the SQL process you want to exclude is sqlbackup

This would go into the top box on the Alert configuration settings for Long-Running Query.

Thanks,


Colin.
Back to top
View user's profile Send private message Send e-mail
NC Software



Joined: 23 Nov 2009
Posts: 5

PostPosted: Fri Jan 24, 2014 3:25 pm    Post subject: Reply with quote

I have the following in the top box and I'm still getting notifications:

[Bb]ackup
SQLAgent
sqlbackup
Back to top
View user's profile Send private message
Colin Millerchip



Joined: 31 Oct 2007
Posts: 62
Location: Cambridge, UK

PostPosted: Fri Jan 24, 2014 5:49 pm    Post subject: Reply with quote

Can you try putting sqlbackup in the second box, as this tends to appear in the SQL command. In fact, to be on the safe side, you could put all three in both boxes, although this may not be strictly necessary.

Thanks,


Colin.
Back to top
View user's profile Send private message Send e-mail
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