Data Pages, Allocation Units, IAM chains... Oh My!

Speaker(s)Brandon Leach

Duration: 60 minutes

Track: Enterprise Database Administration & Deployment

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.