Category: Storage Wednesday

• The Secret of the Database Boot Page

  

  2014-05-28 - General, Series, SQL Server Internals, Storage Wednesday

  The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.

  [more…]

• DBCC FILEHEADER: Reading the File Header Page

  

  2014-05-21 - General, Series, SQL Server Internals, Storage Wednesday

  Every SQL Server database file has a dedicated file header page. Read on to discover how to use DBCC FILEHEADER to explore the header of your database files and learn about the one property of file header pages that might just affect your backup and restore strategy.

  [more…]

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  

  2014-05-14 - General, Series, SQL Server Internals, Storage Wednesday

  The Bulk-Logged recovery mode can provide a performance gain for your database. Check out how SQL Server uses the Bulk Changed Map to make this possible.

  [more…]

• Differential Changed Map (DCM): How SQL Server Tracks Changed Pages

  

  2014-05-07 - Backup, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server uses the Differential Changed Map to determine, which pages changed since the last full backup. Read on to find out how the DCM is working.

  [more…]

• PFS Pages: How SQL Server tracks “Page Free Space”

  

  2014-04-30 - General, Series, SQL Server Internals, Storage Wednesday

  PFS pages contain information about the free space available on all pages in a database file. They contain one byte per page that also holds four additional status bits. Read on to discover how to interpret the PFS data.

  [more…]