Tag: Allocation Unit

• The Allocation Unit

  

  2014-03-26 - DMVs & CVs, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server groups all pages that belong to a single partition of a single index or heap into logical units. These units are called allocation units. Read on to learn about the different types of allocation units and discover how to identify the allocation units belonging to a table.

  [more…]

• The Extent (A Storage Wednesday Post)

  

  2014-03-19 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server organizes database pages in groups of 8 called extents. An extent is the smallest unit that SQL Server will reserve on disk. However, smaller tables are still possible through mixed extents. Read on to get all the details.

  [more…]

• The Page Header (A Storage Wednesday Post)

  

  2014-02-19 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server organizes databases in chunks of 8192 bytes, called pages. Each page starts out with 96 byte of meta-information – the page header. Read on to see what kind of information is stored in this special area.

  [more…]