Query runtime exceeds [min]

What is this alert?

An alert is raised if the total runtime for a query is greater than the specified number of minutes. The alert is raised once per query.

Run time is calculated from the time the query begins to execute. The time the query was queued is excluded.

Alert details

  • query ID
  • database name
  • user name
  • time the query was submitted
  • time the query started

What to do

Use the Query Monitor to check the execution status of the query.

If the query is blocked, investigate the queries that hold the locks.