Basic locking metrics

-- Basic locking metrics (connect to the neccessary database)
SELECT request_session_id, resource_type,
    resource_database_id, DB_NAME(resource_database_id) AS database_name,
    resource_associated_entity_id,
    (CASE resource_type
        WHEN 'OBJECT' THEN OBJECT_NAME(resource_associated_entity_id, resource_database_id)
        WHEN 'DATABASE' THEN DB_NAME(resource_database_id)
        ELSE (SELECT  OBJECT_NAME(pat.[object_id], resource_database_id)
                FROM sys.partitions pat WHERE pat.hobt_id=resource_associated_entity_id)
        END
    ) AS [object_name],
    resource_description, request_mode, request_type, request_status
FROM sys.dm_tran_locks
GO