IAM pages
I have one problem. I am starter in SQL Server 2000, so excuse me if I am saying something wrong. My problem is in understanding of First IAM page and IAM pages. I donât understand exactly how many extents I can map by it. Is IAM page bit or byte oriented?
Example: If I have in First IAM page rows like this:
Extent Bit Map
1 1
2 1
3 1
4 0
5 0
6 1
7 0
8 0
9 0
â¦â¦â¦.
â¦â¦â¦.
Because the capacity of the page is 8KB, can I address approximately 8000 extents (if it is byte oriented) or 8000*8 (if it is bit oriented).
|