Pages and Extents Architecture Guide

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 guide describes the data structures that are used to manage pages and extents in all versions of SQL Server. Understanding the architecture of pages and extents is important for designing and developing databases that perform efficiently.

Link to PDF : Pages and Extents Architecture Guide

Related Posts:

2008R2Internals

SQL Server 2008 R2, like its predecessors, is more than a database engine. It is a
collectio

Azure SQL Server

Azure SQL for beginners is a series to help bring SQL Server professionals to Azure SQL (Azure SQ

SQL Server In-Memory OLTP Internals for SQL Server 2016

In-memory OLTP, frequently referred to by its codename “Hekaton”, was introduced in SQL Serve

SQL Server 2016 and Windows Server 2016: Better Together Technical

Windows Server and Microsoft SQL Server teams are collaborating closely to ensure that the combin