Displays information about the usage and size of all tables, including system and user-defined tables and materialized views.
You can only request page usage statistics if no other users are connected to the database. The page usage information is
obtained using the sa_table_page_usage system procedure, which requires the MANAGE ANY STATISTICS privilege.
The dbinfo utility displays information about a database. It reports the name of the database file, the name of any transaction
log file or log mirror, the page size, the collation name and label, whether table encryption is enabled, and other information.
Optionally, it can also provide table usage statistics and details.
You can use the dbinfo utility to determine the size of a table on disk. To do so, run a command similar to the following:
The result shows you how many pages are used to hold the data in each table in your database (Pages), and the percentage used
of those pages (%used). For any table, you can then multiply the number of pages by the database page size, and then multiply
that by %used to determine the amount of space is being used for your table.
You can also get more information about a database by:
querying individual database properties using the DB_PROPERTY system function.
querying all database properties using the sa_db_properties system procedure.
using the -pd option with the Ping utility (dbping). When you specify -pd, dbping returns the value for each database property
that is specified.