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.