Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DB NewsFeed

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.

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.

Comments

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

Loading comments...