Blog Post

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.

Rate

Share

Share

Rate