Adaptive Server includes several tools that provide information about the current sizes of tables or indexes, or that can predict future sizes:
optdiag displays the sizes and many other statistics for tables and indexes. See Chapter 2, “Statistics Tables and Displaying Statistics with optdiag,” in Performance and Tuning Series: Improving Performance with Statistical Analysis
sp_spaceused reports on the current size of existing tables and indexes.
sp_estspace can predict the size of a table and its indexes, given a number of rows as a parameter.
You can also compute table and index size using formulas provided in this chapter. sp_spaceused and optdiag report actual space usage. The other methods presented in this chapter provide size estimates.
For partitioned tables, sp_helpartition reports on the number of pages stored on each partition of the table. See Chapter 10, “Partitioning Tables and Indexes” in the Transact-SQL Users Guide.