Identify if there is a blocking in your SQL Server

Typically monitoring tool lets database administrators know if there is any blocking on a server. However, you can manually check real-time status of a SQL Server for blocking using below TSQL:

SELECT * FROM SYS.sysprocesses

WHERE blocked <> 0

This will print vital information related to blocking at that time.

Note: This is the most efficient way to capture blocking information from a SQL Server.