Understanding IAM Pages in SQL Server Storage Architecture

SQL Server manages space allocation for tables and indexes using several metadata pages. While GAM, SGAM, and PFS pages track space at the extent and page level, Index Allocation Map (IAM) pages provide the link between allocation units and physical storage locations. Starting with SQL Server 2005, allocation units fall into three categories: ...

Đăng vào ngày 19 tháng 5 lúc 13:54