Red Gate forums :: View topic - Is it possible to add batch request/second 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

Is it possible to add batch request/second alert?

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
henkmeulekamp



Joined: 09 May 2006
Posts: 9

PostPosted: Sun Jan 27, 2013 5:26 pm    Post subject: Is it possible to add batch request/second alert? Reply with quote

Would it be possible via custom metrics or another way to add an custom alert on batch requests / second. And set the threshold value (just like diskpace high, medium, low)?

we have found that one of our sql boxes will overload above a certain value (suddenly many more transaction due to failing caching system). It would be nice if no matter what is causing the extra load of queries, that we would be alerted by sql monitor that one of the instances is moving into danger zone.

Thanks in advance,
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Mon Jan 28, 2013 6:06 pm    Post subject: Reply with quote

It is possible to create a custom alert for this. However, it is not possible to base this alert on an existing metric that the tool collects by default. Instead a new custom metric has to be created to base the alert on.

This link contains a number custom metrics that users have successfully created in the tool, and they may help you with writing your own.
http://sqlmonitormetrics.red-gate.com/
_________________
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