Chapter 38. Locking and Performance

by Ray Rankins


  • 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.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features