Observability

Database Suspended Process Check

This Active Diagnostics Check looks for and reports the top X session IDs by total_elapsed_time, by querying the sys.dm_exec_requests SQL Server DMV. The check returns a warning if there are any session IDs in the 'SUSPENDED' status. These checks have a total_elapsed_time of longer than 1 hour. To get the best information from this check, run the test multiple times to see whether the same query session IDs are still in a suspended state.

First published date

4/19/2022 8:26 AM

Last published date

6/4/2025 2:42 PM

Overview

This Active Diagnostics Check looks for and reports the top X session IDs by total_elapsed_time, by querying the sys.dm_exec_requests SQL Server DMV. 
The check returns a warning if there are any session IDs in the 'SUSPENDED' status. These checks have a total_elapsed_time of longer than 1 hour.
To get the best information from this check, run the test multiple times to see whether the same query session IDs are still in a suspended state.

Product section

Hybrid Cloud Observability

Resolution

Determine the text from this suspended process. This can be helpful for narrowing down where and why the query may be having issues.
Run the following command. Replace SESSIONID with a session ID provided from the test results.

DBCC INPUTBUFFER (SESSIONID)

Use tools such as Activity Monitor, or run the sp_who2 command to gain additional insight into the Program Name, the Hostname, blocking chain information, etc...
This can help indicate why a process may be in a suspended state for a long period of time.
See Understand and resolve SQL Server blocking problems.