-
Allocation Add-in – now with fragmentation information!
-
The latest version of the SSMS Allocation Add-In now includes fragmentation information for each table:
0% – 10% is green, 11% – 20% is orange, and 20%+ is red.
The release also includes a much quicker routine for creating the allocation map as the previous version was very slow for VLDBs.
It can be downloaded here.
-
Allocation Add-in Version 0.2
-
Version 0.2 of the Allocation Add-in has just been released.
It’s available from CodePlex here.
This new version includes support for SQL Server 2008 RTM and has a couple of new features.
The Allocation Map can now be set so that the entire file is rendered to fit the screen without the need for scrolling. This is the default view. Fit map is rendered asynchronously and is also cached.
There’s also the option to toggle on and off the table and allocation map.
-
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.
Release
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?