【SQL Server】Session blocking

最新推荐文章于 2023-11-07 15:55:33 发布

Kingsley_W

最新推荐文章于 2023-11-07 15:55:33 发布

阅读量993

点赞数

本文链接：https://blog.csdn.net/wltom1985/article/details/50737281

版权

本文探讨了SQL Server环境中常见的session blocking问题，详细介绍了如何使用sp_who2、sys.dm_exec_requests、sys.dm_os_waiting_tasks动态管理视图以及Activity Monitor工具来检测和诊断阻塞情况，以维护数据完整性并解决性能瓶颈。

摘要由CSDN通过智能技术生成

In our SQL Server environment, we have frequent blocking across a few different versions of SQL Server. Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes. With this being said, locking is a natural occurrence in SQL Server in order to maintain data integrity. There are number of ways to find out the details of the system processes IDs (spids) involved in blocking.

1. sp_who2