A Graphical View of the Physical Allocation of a Database

2007/07/20

First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The tool gives a graphical representation of how the data is physically allocated. It's currently in beta but has some nice functionality.

Here are the requirements:

Windows 2000 or higher
Microsoft .NET Framework 2.0
SQL Server 2005 SP2

If you're interested in seeing how your database is laid out and looking at the individual pages, give this tool a look! Also, check out the resources page which has great links to articles, blog posts, and documentation on SQL Server internals.

Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2005 | SQL Server Internals | SQL Internals Viewer