iam page

Question

iam page

avraham.elad

SSC Enthusiast

Points: 120
More actions
April 17, 2016 at 6:50 am

#306639

hi ,
i dont understand iam pagei read sevral post and is dont get it,
somone please explain this without qoute msdn ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

avraham.elad (4/17/2016)
hi ,
i dont understand iam pagei read sevral post and is dont get it,
somone please explain this without qoute msdn ?

Without knowing why you need to understand IAM pages, it's not possible to provide you with any more information than what you can find in the following Google search.

https://www.google.com/?gws_rd=ssl#q=what+is+iam+page+in+sql+server

To be succinct, the IAM pages allow SQL Server to keep track of Extents. Slightly more verbosely, "The allocation of pages to a table, index, or an indexed view partition is managed by a chain of IAM pages."

If you don't know what an extent is or how they're related to data and indexes (which aren't much more than a duplication of data in a different logical sort order), then start with these.

https://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx

https://technet.microsoft.com/en-us/library/ms189051(v=sql.105).aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

At a really low level, it's how the storage of the information is maintained. But I'm with Jeff, a better definition of what you're trying to understand, other than just IAM itself is needed.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning