Pages

Sunday, September 1, 2013

SQL SERVER – LCK_M_XXX – Wait Type – Day 15 of 28 | Journey to SQL Authority with Pinal Dave

Locking is a mechanism used by the SQL Server Database Engine to synchronize access by multiple users to the same piece of data, at the same time. In simpler words, it maintains the integrity of data by protecting (or preventing) access to the database object. From Book On-Line: LCK_M_BU Occurs when a task is waiting… Continue Reading...

Source: SQL SERVER – LCK_M_XXX – Wait Type – Day 15 of 28 | Journey to SQL Authority with Pinal Dave