is there a tool to easily profile size usage within a database
I am looking for a database management tool I would have expected to find something like on the SMP website
Aim
show current database usage (ie size allocation) by database then table etc and allow continued drill down,
show information as a table, so can then sort by size to find the biggest item easily
also show it graphically
And then have ability to track and trend growth in size over time
identify a normal growth pattern
alert if variation (higher or lower) from normal based on recent trend
is there a tool that can do this, or a 3rd party tool, even it can only operate via standard SQL JDBC/ODBC to get a partial view.
Or, how else do people manage and track size?