THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Merrill Aldrich

SQL File Layout Viewer 1.2

Just ahead of presenting it at SQL Saturday in my home town of Minneapolis / Saint Paul, I’m happy to release an updated version of the SQL Server File Layout Viewer. This is a utility I released back in March for inspecting the arrangement of data pages in SQL Server files.

If you will be in Minneapolis this Saturday (space permitting), please come out and see this tool in action!

New Features

Based on feedback from others in the SQL Server community, I made these enhancements:

  1. Page types now provide descriptive labels.
  2. There’s a new ‘magnifier.’ Click on any page in the analysis image and the surrounding area is enlarged to make details easier to see.
  3. Two new display options will highlight fragmentation using a red band, and show the amount of free space on pages both graphically and with a readout.
  4. Right-click in the analysis image to run DBCC PAGE from a context menu.

FLV1_2

The utility has been tested with simple demo databases on SQL Server 2005 - 2012, from Windows 7 and 8 clients. It is not compatible with SQL Server 2000, or databases in 2000 compatibility mode. It requires sysadmin rights on the target SQL Server. As always, a reminder: please do not run this tool on a production database, as it will scan the entire thing and may cause performance problems for your server. Scanning a huge database probably will yield unpredictable results.

Details

In the download package you will find an executable file and a Visual Studio 2010 Express Edition solution with all the source code. If you are only interested in running the utility, just run the .exe at the top level of the package. If you are interested in the source code, the complete project is there for your use.

This is free software. You may download and use it as you see fit, but without warranty of any kind. You are welcome to read or modify the source code if you like, but the code is bound to the included GPL (GNU General Public License) and you may not patent or sell it.

Published Wednesday, October 09, 2013 2:09 PM by merrillaldrich

Attachment(s): SQLFileLayoutViewerR1_2.zip

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Merrill Aldrich said:

Edit 9 October 2013: A new version is out! Please download 1.2 from here . Back in the Spring I released

October 9, 2013 4:14 PM
 

Merrill Aldrich : Public Release, SQL Server File Layout Viewer said:

October 9, 2013 4:16 PM
 

Dave said:

I love this tool, thanks for keeping up with new features!

October 10, 2013 9:42 AM
 

sateesh said:

Thanks for sharing this tool

December 29, 2013 4:34 AM
 

Merrill Aldrich said:

I am happy to offer a session on Storage Internals using File Layout Viewer at the Minneapolis SQL Server

January 20, 2014 1:01 PM
 

Merrill Aldrich said:

I'm very excited to be speaking at SQL Saturday Chicago again tomorrow, 4/26. I'll be doing a deep dive

April 25, 2014 9:03 AM
 

SQL File Layout Viewer at SQL Saturday Chicago 2014 | TGS said:

May 5, 2014 3:19 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement