摘要:
从SQL Server的Online Book里面描述Deadlock策略里面发现有下面的一种情况:
Worker threads. A queued task waiting for an available worker thread can cause deadlock. If the queued task owns resources that are blocking all worker threads, a deadlock will result. For example, session S1 starts a transaction and acquires a shared (S) lock on row r1 and then goes to sleep. Active sessions running on all available worker threads are trying to acquire exclusive (X) locks on row r1. Because session S1 cannot acquire a worker
阅读全文
posted @ 2010-07-30 11:01
firewing
阅读(3607)
推荐(7)
编辑