SQL Server Performance

locks in sqlserver 2005

Discussion in 'Getting Started' started by priyaram, Apr 25, 2007.

  1. priyaram New Member

    is there any good documentation about the locks, since i just started to working on locks i need to know more information, locks, types , esculation

    thanks
  2. satya Moderator

  3. MohammedU New Member

    Check the following from BOL and SQL Server Storage Engine Blog...

    SQL Server 2005 Books Online
    Lock Compatibility
    http://msdn2.microsoft.com/en-us/library/ms186396.aspx

    Locking in the Database Engine
    http://msdn2.microsoft.com/en-us/library/ms190615.aspx

    Lock Escalation (Database Engine
    http://msdn2.microsoft.com/en-us/library/ms184286.aspx

    http://blogs.msdn.com/sqlserverstorageengine/archive/2006/05/17/600132.aspx

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page