|
- Header: 96-bytes. (page#, type, free space, allocation unit ID of the object that owns the page)
- data rows: inserted serially in the page.
Types of Pages:- Data
- Index
- Text/Image
- Global allocation Map: extent allocation info
- Shared allocation Map: extent allocation info
- Page Free Space: free space info
- Index allocation map: extents used by table or index per allocation unit.
- Bulk changed map: extents modified by BULK ops since last
BACKUP LOG
- Differential Changed Map: extents modified since last
BACKTUP DATABASE
|
ReplyDeleteNice Article !
Really this will help to people of SQL Server Community.
I have also prepared small note on this, Internal architecture of SQL Server Extent
http://www.dbrnd.com/2016/04/sql-server-understanding-the-role-of-extent/