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
Reviews
There are no reviews yet.