1 Reply Latest reply on Mar 21, 2016 3:01 PM by mandevil

    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?

        • Re: Alert for Sql waiting queries
          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.