Tagged Questions
1
vote
1answer
65 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
228 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 ...
