What’s New in Locking and Performance
SQL Server 2008 doesn’t provide any significant changes in locking behavior or features over what was provided in SQL Server 2005 (such as Snapshot Isolation and improved lock and deadlock monitoring). The main new feature in SQL Server 2008 is the capability to control lock escalation behavior at the table level. The new LOCK_ESCALATION table option allows you to enable or disable table-level lock escalation. This new feature can reduce contention and improve concurrency, especially for partitioned tables.
One other change for SQL Server 2008 is the deprecation of the Locks configuration setting. This option, while still visible and settable in sp_configure, is simply ignored by SQL Server 2008. Also deprecated ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
