Saturday, January 26, 2013

Visualizing SQL Server Data Files

Here are a couple of interesting posts/tools that allow you to visualize the contents of a SQL Server database. They also help to illustrate the importance of physical page layout with regards to importance (e.g. be careful of AutoShrink in production databases!)

Visualizing Data File Layout I, by Merrill Aldrich
Visualizing Data File Layout II, by Merrill Aldrich
Internals Viewer for SQL Server, by Danny Gould

No comments:

Post a Comment