Edit 9 October 2013: A new version is out! Please download 1.2 from here.
Back in the Spring I released a 1.0 version of a utility that will show the structure of SQL Server files graphically. Today I have a new release that includes some fixes and updates based on user feedback, bug reports, and suggestions.
In this release:
- The database scan is significantly faster because it now uses parallelism.
- Larger databases are supported, and files over 4GB are now read correctly – but don’t go too crazy. Really large data sets are not likely to work.
- SQL Server Auth is now available.
- Various bug fixes around pages that contained data at one time but are not currently allocated, and pages “captured” from other databases via instant file initialization.
Fundamentals about the app are the same:
- The app will read a database and then present a color-coded visualization of all the data by object and by page type.
- Mouse over the visualization to get details about the pages in a panel on the right edge of the app window.
- Use this in test, not production. It’ll scan the whole database, which probably would be performance impacting.
- This is designed to study and learn about storage internals using modest data sets. Running it on a large warehouse, for example, is probably not going to work.
I want to thank those in the SQL community who helped with this project via Twitter, testing for me, bug reports and critiques. You know who you are, and y’all rock :-).