开发者

SQL SPID Blocking itself

开发者 https://www.devze.com 2023-01-01 04:56 出处:网络
I\'m running SQL Server 2000. I have a situation where users are timing out. In enterprise manager I look at the locks/ProcessIDs.

I'm running SQL Server 2000.

I have a situation where users are timing out.

In enterprise manager I look at the locks/ProcessIDs.

I see

   spid 79开发者_StackOverflow社区 (Blocked By 79)

How is it possible for a session to block itself?


This was introduced with Service pack 4 in SQL Server 2000. See this KB article: http://support.microsoft.com/kb/906344 for an explanation

When an SPID is waiting for an I/O page latch, you may notice that the blocked column briefly reports that the SPID is blocking itself. This behavior is a side effect of the way that latches are used for I/O operations on data pages

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号