tags:

views:

36

answers:

1

Does anyone know of any tools that can be used to visualize data in a SQL Server database?

I'm specifically interested in a tool that can show measures such as number of rows, size of table in bytes, number of columns, using multi-dimensional graphs.

A 2D example might use a circle for each table, where the relative size of the circle indicates size in bytes, and colour indicates number of rows.

+3  A: 

SQL Server management studio has features that do some of these things. Right click on the database, select "Reports" then "Standard Reports" and then which ever one you need.

It doesn't do graphs for all of them (but some do), but the tables it produces can be quite useful. For example, it's got "Disk usage by table", "Top transactions by age" and so on.

Dean Harding
Not quite what I was after, but close enough, thanks.
Sam