Database Page

[Total: 15   Average: 3.7/5]

Every piece of data in SQL Server is stored in 8 KB database pages. A page is a basic unit of I/O operation. A page starts with a 96-byte header in which all system information (the amount of free space, the page type, the page number, and the allocation unit ID of the object that owns the page) is stored. Another part of the page is its body or data rows (8,060 bytes). The body contains all the data in rows. The last part of the database page is row offsets that are located in reverse sequence from the sequence of the rows on the page (36 bytes).

Database Page

Page Types

There are several types of database pages:

  1. Data Page details how the data is stored inside the data files, database.
  2. Index Page contains index entries.
  3. Text and Image contains textual and image data.
  4. GAM (Global Allocation Map) and SGAM (Shared Global Allocation Map) contain information about whether extents are allocated.
  5. PFS (Page Free Space) contains information about the free space available on pages and about page allocation.
  6. IAM (Index Allocation Map) contains information about extents used by a table or index.
  7. Bulk Changed Map contains the extent information that has been modified by bulk operations since the last BACKUP LOG.
  8. Differential Changed Map contains the extent information that has changed since the last BACKUP DATABASE.