SQL Server Locks Dashboard column Index name and Object Name display N/A. (4294855)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Server Locks Dashboard column Index name and Object Name display N/A.
Description

SQL Server Locks Dashboard column Index name and Object Name displays N/A.
Resolution

Index Name: The index that is being used by the current process (if any).
Object Name: The name of the currently locked object.
The Lock Type column could take one of the following values (resource_type from sys.dm_tran_locks): DATABASE, FILE, OBJECT, PAGE, KEY, EXTENT, RID, APPLICATION, METADATA, HOBT, or ALLOCATION_UNIT.
Object IDs and Index IDs are not associated with DATABASE lock types.
Information on lock types can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title