Aborted executions

An execution is set to be aborted if it has been forcefully stopped, or the execution has timed out.

To query the Performance Store database for aborted executions, use:

select a.*
from dbo.v_top_completed a
where 1 = 1
and a.sample_id = '[sample_id]'
and a.server_name = '[server_name]'
and a.database_name = '[database_name]'
and a.result = 'Abort'

If an execution is aborted and the duration is close to a standard timeout value (e.g. 30 or 600), then it is usually a timeout:

A quick overview of the number of aborted executions can be seen on the Overview 1 dashboard:

In-depth information about the aborted execution can be seen on the Top completed queries dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.