Tag: IAM page

• The GAM Interval and GAM Extents

  

  2014-04-09 - General, Series, SQL Server Internals, Storage Wednesday

  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.

  [more…]

• The Index Allocation Map (IAM)

  

  2014-04-02 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server tracks the pages that belong to an allocation unit through special index allocation map pages, also called IAM pages. Each IAM page covers a single GAM-interval of the database file. All IAM pages of a single allocation unit together build an IAM-chain. Read on to find out more.

  [more…]