Physical Database Architecture

The topics in this section describe how SQL Server 2005 databases and files are organized.

Topic Description

Pages and Extents

Describes data storage architecture.

Physical Database Files and Filegroups

Describes the set of operating-system files used to store data and log files.

Space Allocation and Reuse

Describes the space allocation algorithms and data structures. It also provides users and administrators with the knowledge they require to understand the references to the terms in the messages generated by SQL Server.

Table and Index Architecture

Describes the way the pages for tables and indexes are organized.

Community Additions