4 out of 4 rated this helpful - Rate this topic

Pages and Extents Architecture

SQL Server 2008

SQL Server 2008 R2

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.

In This Section

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD