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.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net