The lock-escalation tag has no wiki summary.
1
vote
1answer
71 views
SQL Server 2008 - get current LOCK_ESCALATION on particular table
Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
4
votes
1answer
245 views
Why isn't partition-level lock escalation the default?
In SQL Server, locks are normally escalated from row or page -> table. Starting with SQL Server 2008, a new level of lock escalation was added - partition level.
However, this isn't automatically ...
4
votes
2answers
4k views
can I resolve a deadlock with the rowlock hint?
I have a large delete stored proc and I've reproduced a deadlock in a situation where the deletes would not have deleted anything.
It looks like the part of the stored proc that hit a deadlock was ...
15
votes
3answers
4k views
What is lock escalation?
I was asked this question at an interview and had no answer. Can anyone here explain?
