Friday, October 11, 2013

Could SQL Server lock partitioning cause deadlock?

I do not believe the last digit is the lock partition number, but rather the index_id.


Internal structures such as the lock partitions are not managed the same as user data, so it is not possible to deadlock on the lock partition structure itself.


Without seeing more details about your deadlock, to me it looks like a normal deadlock situation.




HTH, Kalen Delaney www.SQLServerInternals.com

No comments:

Post a Comment