Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-08-06 : 03:51:58
|
| Hi Team,Recently, am going through the some of storage engine concepts and allocation in sql server and am little bit confused about the below concepts.Can anyone explain me in simple terms so that i can understand them betterWhen does a PFS page actually gets created?What is an IAM page and what for it is used?Does IAM page is used for Heap also or it only exist for clusterred index table?What is a IAM chain?What is Allocation unit? Also, assume i have created a sample heap table and am INSERTing a row for the first time, what will happen in the background?How does GAM, SGAM , PFS , IAM etc... work internally and finally allocated a data page to insert the row.Am looking for simple explaination for my mapping purpose. While reading the msdn documentaion, everything is on top of head.Any help would be greatly appreciated.Thanks in Advance, |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Understanding of page allocation