Alert for Sql waiting queries

nvyguardsman

One of the admins came to me today and asked if I could create an alert for him that would email notify when one of the MSQL DB's goes above "10 querries/tasks waiting".  I don't see anything like that available.  I've seen a few people create alerts for "query wait time" but never the amount of querries waiting to be run.  Can anyone help?

mandevil

If you've got the SQL that can pull the numeric, this could easily be built into DPA as a custom metric that can then be alerted on.

Got to options -> custom metric and walk through the template. It's pretty self-explanatory, but if you still need assistance, you might create a ticket with support.