Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunny Parallel Processing RE: Parallel Processing
qiyuef
SSC Enthusiast
Points: 110
More actions
October 14, 2009 at 2:34 pm
#1065973
Can you explain why there will be a deadlocks when SQL Server doesn't perform a lock escalation even when the batch size is high?
Each process will lock different sets of key(rows) , I don't understand how deadlock could happen.
Thanks