阅读背景:

SQL Server——为什么我的SPID在创建索引时被“挂起”而没有被阻塞?

来源:互联网 

I have a SQL 2005 x64 server, and when I attempt to issue some queries against it (for example, when I try to create an index), my SPID goes to "sleeping" immediately, and seems to wait there indefinitely. It's not being blocked (the "BLKBY" column in SP_WHO2 is empty), and the CPU and DiskIO values are very small (under 300 each), and not growing.I have a SQL 2005 x64 server, and when I attemp




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: