I’m going to start a series of posts talking about SQL Server allocation pages and corruption. Each post will have samples showing how SQL Server use these pages and scenarios of corruption.
The first post will talk about the Extents, PFS, GAM, SGAM and IAM and related corruptions, you can find all concepts from following two pages:
As there are many concepts and samples, I’m going to discuss the topics in two or three posts.
Extents are the basic unit in which space is