Database visualizer tools for SQL Server?
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 gra开发者_如何学编程phs.
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.
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.
精彩评论