IAM stands for Index Allocation Map: To catalog all the pages that belong to a single allocation unit, SQL Server utilizes a
special type of pages, the Index Allocation Map or IAM pages. Each allocation unit has at least one IAM Page; depending on
the size of the table there might be many. The page type of an IAM page is 10.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment