SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cool Tool – SQL Space Map

I came across a cool open source tool called “SQL Space Map“.

The tool, written by Ryan McCauley, presents a visual representation of table and index sizes:

SQL Space Mapper screenshot 1

It can be very handy when you need to quickly understand what are the main tables in a database.

It can also help you spot situations where the indexes of a table take a great amount space, perhaps more than they should.

I think the main use cases for this tool are when you see a new system and want a quick jump start, whether you are a consultant, start in a new work place or handed a new system.

Take into account it can take some time for the tool to run if you have a-lot of tables and indexes in the database.

Matan Yungman

Matan Yungman is a Technical Evangelist and senior consultant at Madeira SQL Server Services. His job is to get the word out about SQL Server. He speaks, lectures, writes, teaches and consults about SQL Server, focusing mainly on performance tuning, database development, high availability and database design. He’s passionate about SQL Server, technology and the SQL Server community.


Leave a comment on the original post [www.dbnewsfeed.com, opens in a new window]

Loading comments...