SQL Server Storage Internals – Part 1

Home/Administration, SQL Server/SQL Server Storage Internals – Part 1

SQL Server Storage Internals – Part 1

$15.00 $4.00

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

Categories: ,

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.