How to identify blocking in SQL Server

How to identify blocking in SQL Server

• Activity Monitor
• SQLServer:Locks Performance Object
• DMVs
  • sys.dm_exec_requests
  • sys.dm_tran_locks
  • sys.dm_os_waiting_tasks
• SQL Server Profiler Locks Event Category

exec sp_who2

select * from sys.dm_tran_locks

SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
resource_type, resource_description
FROM
sys.dm_tran_locks l
JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

DBCC inputbuffer (SPID)

USE master;
GO
KILL spid | UOW [WITH STATUSONLY]
GO

DBCC opentran (Database)