Red Gate forums :: View topic - Need help configuring Long Running Query alert...
Return to www.red-gate.com RSS Feed Available

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

Need help configuring Long Running Query alert...

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kmonroe@psecu.com



Joined: 06 Dec 2012
Posts: 5
Location: Pennsylvania, US

PostPosted: Thu Dec 06, 2012 8:28 pm    Post subject: Need help configuring Long Running Query alert... Reply with quote

Hey All...

I'm working through some alert configurations in SM and I have a SQL Server maintenance plan that is generating a lot of alerts for processor utilization, physical memory and long running queries on one of my servers.

This is a third party maintenance plan and we have accepted the run times of this process.

Right now I'm trying to configure SQL Monitor to ignore anything from this process but I'm unable to see the SQL process in the current alerts to add to the alert configuration to exclude.

Does anyone know how to exclude a SQL Server maintenance plan for at least the long running query alert?

Any help will be greatly appreciated.

Happy Holidays!!

Kevin
_________________
Kevin Monroe
SQL Server DBA
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Tue Dec 11, 2012 2:46 pm    Post subject: Reply with quote

In the Long-Running query alert you have the option to add Regular Expressions.

For example, to exclude any sql backup job, you can add the RegEx of "sqlbackup". This means that any job which uses the sqlbackup extended stored procedure in the script will not be alerted on.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
kmonroe@psecu.com



Joined: 06 Dec 2012
Posts: 5
Location: Pennsylvania, US

PostPosted: Wed Dec 12, 2012 1:30 pm    Post subject: Reply with quote

Chris - Thank you for the reply. I've used regular expression exclusions for other alert configurations. My issue is that the process that is displayed when the maintenance plan runs is "SQL Server Management Studio". If I excluded this process any long running query that a user runs from SSMS would be excluded.

I think I'm going to have to use Regular Expression to exclude the TSQL that the plan executes.

Any other ideas?

Regards!

Kevin
_________________
Kevin Monroe
SQL Server DBA
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