SQL Server uses the Differential Changed Map to determine, which pages changed since the last full backup. Read on to find out how the DCM is working.
PFS pages contain information about the free space available on all pages in a database file. They contain one byte per page that also holds four additional status bits. Read on to discover how to interpret the PFS data.
Discover how SQL Server tracks mixed extents containing free pages using a Shared Global Allocation Map made up of one SGAM page per GAM Interval.
What is a GAM extent in SQL Server? What is a GAM Interval and how big is it really? Read on now to get the answers to these questions and see why a GAM interval is not 64000 extents.