Storage is a core component of any RDBMS system. In SQL Server, the smallest unit of storage is page. Every page is about eight KB in size and has three main sections; page header, page record and row offset array. Depending upon the contents of the records we can have different types of pages. Extent is a collection of eight continuous pages. In the first exercise of this lab we will explore database pages and their types. In the second exercise we will look at different types of records. And in the third exercise we will look at extents and their types.

Subscribe to Download


Version1.0
Download8
File Size876.42 KB
Create DateSeptember 7, 2016
Last UpdatedSeptember 12, 2016
SQL Server Transaction Log Internals Part 1
SQL Server Storage Internals Part 2