microsoft:microsoft_sql_server:sql:performance:check_sql_server_locking_and_blocking

Microsoft - Microsoft SQL Server - SQL - Performance - Check SQL Server locking and blocking

Get information on blocking:

SELECT * 
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)

microsoft/microsoft_sql_server/sql/performance/check_sql_server_locking_and_blocking.txt · Last modified: 2021/08/05 13:44 by peter