Identify blocked processes or long nunning query in SQL Server
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.