Page division case for SQL Server data files

--------------------------------------------------------------------------------------------------------------- -------------------

1. File Header page:

2. Page Free Space page:

3. GAM:

If the corresponding area is occupied corresponding to the bit is 0, if the area is not occupied corresponding to the bit is 1, each GAM can cover 4GB of data every 511 230 pages will have a GAM page.

4, SGAM:

If each page in the zone is occupied by the corresponding bit is 0, if the page is not occupied the corresponding bit is 1; every 511 230 pages will have a Sgam page.

5. IAM:

It records objects such as Tablea,indexa .... The collection of pages that are occupied.

Page division case for SQL Server data files