jump to navigation

Using SQL Space Map July 16, 2012

Posted by fofo in Sql Server, SQL Server 2012.
Tags:
trackback

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!!!

Comments»

1. Dot Net Rules : Using SQL Space Map - July 16, 2012

[…] it very easy to identify space utilisation for a particular database in our SQL Server instance. (read more) Share Posted: Δευτέρα, 16 Ιουλίου 2012 7:11 μμ από το μέλος […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: