Using SQL Space Map July 16, 2012Posted by fofo in Sql Server, SQL Server 2012.
Tags: SQL Space Map
In this rather short post , I would like to talk about a very handy and easy to use tool (SQL Space Map) that makes it very easy to identify space utilisation for a particular database in our SQL Server instance.
This is a codeplex project and you can download it here . This tool helps to identify large objects,objects with a high index/data ratio and tables which may be growing more quickly than expected.
Installation of this tool is really straight forward. When you run it for the first time, you need to specify the server instance you are connecting to, the database and whether you are connecting using SQL Server or Windows authentication.
I launched the SQL Space Map application , I have connected to my local instance of SQL Server 2012 Developer edition through Windows authentication to the AdventureWorks2012 database. When I do that I can see a visual representation of the database objects in my database and their respective size. Make sure you hover over the various tables and indexes.
Please have a look at the picture below
We have also the Standard Reports that are available out of the box for SQL Server 2012 and provide similar information.But I prefer the visual representation that SQL Space Map tool provides.
Have a look at the picture below
Hope it helps!!!