Chapter 38. Locking and Performance
by Ray Rankins
IN THIS CHAPTER
The Need for Locking
Transaction Isolation Levels in SQL Server
The Lock Manager
Monitoring Lock Activity in SQL Server
SQL Server Lock Types
SQL Server Lock Granularity
Lock Compatibility
Locking Contention and Deadlocks
Table Hints for Locking
Optimistic Locking
This chapter examines locking and its impact on transactions and performance in SQL Server. You will also review locking hints that can be specified in queries to override SQL Server's default locking behavior.
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.