Allocation Information Add-in
First of all, my apologies. I’ve been busy with work and other stuff so I haven’t had much spare time to update this blog or SQL Internals Viewer.
One thing I have been working on is a new free add-in for SQL Server Management Studio called the Allocation SQL Server Management Studio Add-in (maybe it needs a better name...)
Recently I’ve been working on refactoring a large database. I wanted a quick way of seeing in which tables the majority of data was stored in, but it’s not that easy without using sp_spaceused or querying DMVs.
The add-in makes space allocation easy to see by creating a new screen in SSMS (both 2005 and 2008) that has a table and displays things like table size and row numbers, and also the percentage of the database the table uses.
As you can see from the screenshot it includes an Allocation Map similar to SQL Internals Viewer. I see the possible* future of the add-in as a version of the Internals Viewer that is more geared towards DBA use. I’m going to add in fragmentation information soon.
The add-in is my entry to the SQL Heroes competition. I’ve created the project in Codeplex (http://www.codeplex.com/) so you can view and download the source code.
I’m warming to Codeplex, and releasing the source of SQL Internals Viewer is something I’ve had in mind for a while, so it’ll probably go in there too.
The release 0.1 of the add-in can be downloaded here
*I use possible as the add-in could also turn into Internals Viewer 2. Which would you prefer – standalone as it is now or integrated with SSMS?