4 Replies Latest reply on Feb 2, 2016 7:48 PM by mandevil

    monitor single query's execute time with DPA alerts

    frankwang

      I have an important query which runs to one SQL2012 database hundreds of time each day.It is time sensitive,which mean usually its execute successful time is ~5s,but sometimes it will up to 1~2mins(should be database performance issue).and if its execute time is > 30s,there will be timeout error happen to its back end application.So I want to create an alert to monitor this execute time,when it is >30s,there will be alert mail to me,then we can look into the database to find what is the issue.This will help us to be sure/monitor this query runs well all the time.

      I do not find out how to do this in "alerts" area,so pls advise.

       

      about the query,its output is batch data of 5000 records&10 columns,but not single numric