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

Get information on blocking:

<code sql>
SELECT * 
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
</code>