Hands-On-Lab: SQL Server Heap Internals

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Heap Internals.

A heap is a table without a clustered index. One or more non-clustered indexes can be created on a heap. This lab is divided into three exercises. In the first exercise we will look at different types of allocation units available in SQL Server. In the second exercise we will observe how page modification is done in a heap and in the third exercise we will troubleshoot I/O issues related to page modification in heap.

Exercise 1: Allocation Units in a Heap
Exercise 2: Page Modifications in a Heap
Exercise 3: Troubleshooting Heap Page Modifications

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.