Identify Blocked SQL Processes Quickly

摘要

Your database can be a primary source of poor application performance. Create your own utility that tells you which processes are being blocked and which process is causing the blocking. The system stored procedure sp_who2 is a well-known SQL Server utility that determines which processes are running on the databasernserver and which processes are being blocked, thus slowing down application performance. However, this utility doesn't easily identify the root cause of the blocking or the dependency of the blocked processes. Developing your own utility can solve these problems.