Pages and Extents Architecture

The page is the fundamental unit of data storage in SQL Server. An extent is a collection of eight physically contiguous pages. Extents help efficiently manage pages.

This section describes the data structures that are used to manage pages and extents. Understanding the architecture of pages and extents is important for designing and developing databases that perform efficiently.

Understanding Pages and Extents

Describes how data is stored in pages and extents.

Managing Extent Allocations and Free Space

Describes the SQL Server data structures that manage extent allocations and track free space.

Managing Space Used by Objects

Describes how space is allocated for objects.

Tracking Modified Extents

Describes internal data structures that help track extents modified by bulk copy operations and extents modified since the last full backup.