Table Size vs Database Size

[former_SQLA_member1694868]

What is the best way to determine which tables are the culprits in a large (disk size) database.

We put out the same basic structure of tables to our customers and some databases end up much bigger than others. My initial attempts to determine where the size is used were to check the row counts for each table, but I do not think I am doing that as efficiently as I could, going table by table. But a higher row count does not necessarily mean more space on the disk if another lower row count table is storing more data.

I also checked in Sybase Central the Fragmentation for the tables with the most main pages, as well as the %File column of Page Usage which I assume means the % of the database file that table uses.

So I thought I would ask if there is a more efficient, more accurate way to tell which tables were taking up the most disk space within the database file.

[johnsmirnios]

dbinfo -u is a convenient way to get the information from the command line. It's probably equivalent to the information displayed in Sybase Central. Builds 2630 and later of 12.0.0 as well as all versions of 12.0.1 gather this information much more quickly when it is not already in cache.