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 |
