DESCRIPTION
This alert will list SQL Statements that have recently executed outside their normal execution time. The previous 30 days are compared when calculating the average execution time for a SQL. The results are reported back in percentage above normal executions time, e.g. if 200 is returned that means the query executed twice as long on average within the last hour than normal.
Warning: This alert supports SQL Server repositories only.
Available Database Instances: All database platforms being monitored are supported as this alert executes against the DPA repository.
ALERT DEFINITION
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the attached query. Note that the Execute Against dropdown should be set to Repository.
