Thursday, February 21, 2013

SQL Server Locking Wait Types

Like other RDBMS, Microsoft’s SQL Server use locks to prevent multiple users from making conflicting changes and deletion to a set of data. When a set of data is locked by any user, then no other users can modify that same set of data until the first user finishes modifying the data and releases the lock.


LCK_M_BU   :   Occurs when a task is waiting to acquire a Bulk Update (BU) lock.

LCK_M_IS      :    Occurs when a task is waiting to acquire an Intent Shared (IS) lock.

LCK_M_IU      :    Occurs when a task is waiting to acquire an Intent Update (IU) lock.

LCK_M_IX      :    Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock.

LCK_M_S        :    Occurs when a task is waiting to acquire a Shared lock.

LCK_M_SCH_M      :    Occurs when a task is waiting to acquire a Schema Modify lock.

LCK_M_SCH_S       :    Occurs when a task is waiting to acquire a Schema Share lock.

LCK_M_SIU     :    Occurs when a task is waiting to acquire a Shared With Intent Update lock.

LCK_M_SIX     :    Occurs when a task is waiting to acquire a Shared With Intent Exclusive lock.

LCK_M_U        :    Occurs when a task is waiting to acquire an Update lock.

LCK_M_UIX     :    Occurs when a task is waiting to acquire an Update With Intent Exclusive lock.

LCK_M_X         :     Occurs when a task is waiting to acquire an Exclusive lock.
Understanding Locking in SQL Server. Lock Modes. different types of locks available in sql server. SQL Server Wait Types - Locking. Lock Types and Compatibility. Understanding SQL Server Locking. SQL Server Lock Types. sql server lock type tab. lock in sql server 2008. lock in sql server 2012. exclusive lock sql server 2008 R2. sql server read lock. transactions and locks in sql server. types of locks in sql server 2005. types of locks in sql server 2012. Introduction to Locking in SQL Server. SQL Server Lock Types. Locking in SQL Server. SQL Server Locking Mechanism. SQL Server. Locks Object.

0 comments:

Post a Comment