Skip to content

Commit 5415e1b

Browse files
Added blocking_session_id -5
1 parent b1a59d9 commit 5415e1b

1 file changed

Lines changed: 2 additions & 2 deletions

File tree

docs/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
description: "sys.dm_exec_requests (Transact-SQL)"
33
title: "sys.dm_exec_requests (Transact-SQL) | Microsoft Docs"
44
ms.custom: ""
5-
ms.date: 10/01/2019
5+
ms.date: 9/17/2021
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database"
88
ms.technology: system-objects
@@ -45,7 +45,7 @@ Returns information about each request that is executing in [!INCLUDE[ssNoVersio
4545
|database_id|**smallint**|ID of the database the request is executing against. Is not nullable.|
4646
|user_id|**int**|ID of the user who submitted the request. Is not nullable.|
4747
|connection_id|**uniqueidentifier**|ID of the connection on which the request arrived. Is nullable.|
48-
|blocking_session_id|**smallint**|ID of the session that is blocking the request. If this column is NULL or equal to 0, the request is not blocked, or the session information of the blocking session is not available (or cannot be identified).<br /><br /> -2 = The blocking resource is owned by an orphaned distributed transaction.<br /><br /> -3 = The blocking resource is owned by a deferred recovery transaction.<br /><br /> -4 = Session ID of the blocking latch owner could not be determined at this time because of internal latch state transitions.|
48+
|blocking_session_id|**smallint**|ID of the session that is blocking the request. If this column is NULL or equal to 0, the request is not blocked, or the session information of the blocking session is not available (or cannot be identified).<br /><br /> -2 = The blocking resource is owned by an orphaned distributed transaction.<br /><br /> -3 = The blocking resource is owned by a deferred recovery transaction.<br /><br /> -4 = Session ID of the blocking latch owner could not be determined at this time because of internal latch state transitions.<br /><br /> -5 = Session ID of the blocking latch owner could not be determined because it is not tracked for this latch type (for example, for an SH latch).|
4949
|wait_type|**nvarchar(60)**|If the request is currently blocked, this column returns the type of wait. Is nullable.<br /><br /> For information about types of waits, see [sys.dm_os_wait_stats &#40;Transact-SQL&#41;](../../relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql.md).|
5050
|wait_time|**int**|If the request is currently blocked, this column returns the duration in milliseconds, of the current wait. Is not nullable.|
5151
|last_wait_type|**nvarchar(60)**|If this request has previously been blocked, this column returns the type of the last wait. Is not nullable.|

0 commit comments

Comments
 (0)