Storage Architecture
Records->Pages->Extents->Files->Database Pages:The SQL Server page size is 8 KB. This translates to 128 pages per megabyte for SQL Server databases. Each page starts with a 96-byte header that contains system information about the page. This information includes the page number, page type, page size, and the allocation unit ID of the object that owns the […]
Continue Reading