Hands-On-Lab: SQL Server Storage Internals – Part 1

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Storage Internals – Part 1.

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.

Exercise 1: Page
Exercise 2: Records
Exercise 3: Extent

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.