SQL Server Locks

preview_player
Показать описание
How to get active lock resources in SQL Serve ?
How to get information about currently active lock manager resources in SQL Serve?
What Is SQL Server locks and Lock mode
What Is Lock Escalation?
what Is Lock compatibility ?
Define Key-range locks in SQL server ?

script get information about currently active lock manager resources in SQL Serve

SELECT
SP.spid,
SDTL.Request_session_id ,
SP.blocked, SP.status,
SP.loginame , SDTL.Resource_type
, DB_NAME (resource_database_id) Database_name
, SDTL.Request_mode
, SDTL.Request_type
, SDTL.Request_status
, SDTL.Request_reference_count
, SDTL.Resource_associated_entity_id
, DEST.TEXT
ON SDTL.request_session_id = SP.spid
WHERE SP.dbid = DB_ID()
ORDER BY SDTL.[request_session_id];
Рекомендации по теме
welcome to shbcf.ru