Page History

...

     The Lock Statistics chart displays all the lock object statistics, helping you to pinpoint, correct, or reschedule automated applications that cause extensive row, table, or database locking. The chart includes the following objects. 

• • AllocUnit - Represents a lock on an allocation unit.
  • Application -   Represents a lock on an application-specific resource.

  • Database -   Represents a lock on a database, including all objects in the database.

  • Extent - Represents a lock on a contiguous group of eight pages.

  • File - Represents a lock on a database file.

  • HoBT - (Heap or BTree) Represents a lock on a heap of data pages, or on the BTree structure of an index.

  • Key - Represents a lock on a row in an index.

  • Latch - Represents a lock on a latch.

  • Metadata - Represents a lock on a piece of catalog information, also called metadata.

  • Object - Represents a lock on an item such as a table, stored procedure, or view, including all data and indexes. The object represents anything that has an entry in sys.all_objects.

  • Page - Represents a lock on an 8 KB page in a database. 

  • RID - (Row ID) Represents a lock on a single row in a heap.

  • Table - Represents a lock on a table.