Microsoft SQL Server File Layout Viewer
Utility to visually inspect the layout of all the pages in a SQL Server database's physical files, showing page type, fragmentation and free space.

This project is a small Windows Forms application that graphically displays the layout of data pages in SQL Server .mdf and .ndf files, for training, demos, and for physical database design.

The viewer provides a colored "map" of all the data pages in a database across files and filegroups, and color codes them by
  • Type
  • Allocation
  • The object they belong to (partition or allocation unit)
  • Fragmentation
  • Page Free Space

SQLFLVCapture.JPG

This project is freeware offered under GPL and is not affiliated, endorsed or branded by Microsoft.

Merrill Aldrich, Saint Paul, MN October 2014

Last edited Oct 23, 2014 at 11:44 PM by merrillaldrich, version 2