Author Bio

Brian is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a database administrator / architect for AgFirst Farm Credit Bank where he can concentrate on his passion: SQL Server. He previously was a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical community, Brian is president of the Midlands PASS Chapter, an official chapter of PASS. Brian is also a junior high youth minister at Spears Creek Baptist Church in Elgin, SC.

Author's SSC Profile
View this Author's Articles

A Graphical View of the Physical Allocation of a Database

By K. Brian Kelley in K. Brian Kelley - Databases, Infrastructure, and Security | 07-20-2007 4:20 PM | Categories: Filed under: SQL Server 2005, Tools

Rating: (not yet rated) |

Discuss | 1,581 Reads | 41 Reads in Last 30 Days |no comments

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

Comments

There are no comments on this post

K. Brian Kelley - Databases, Infrastructure, and Security

A Graphical View of the Physical Allocation of a Database

About Me

Links