Is it possible to add batch request/second alert?

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Is it possible to add batch request/second alert?

Postby henkmeulekamp » Sun Jan 27, 2013 5:26 pm

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,
henkmeulekamp
 
Posts: 9
Joined: Tue May 09, 2006 5:56 pm

Postby chriskelly » Mon Jan 28, 2013 6:06 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests