A Graphical View of the Physical Allocation of a Database


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