The Disk Usage by Top Tables Report in SQL Server is a quick way to get sizes of all tables within a database. If you’re noticing a database is getting large, then you’ll probably want to know what data is causing the increase. Knowing your largest table(s) helps you make better decisions, for example when forecasting disk space requirements, or prioritizing a focus on resolving inefficiencies within the database (e.g. data types/compression).
There are many ways to check the size of a table in SQL Server which I’ve posted about here if you’d like to know more. Below is how to open this report in SQL Server Management Studio.
Right-click a database, select Reports, Standard Reports and Disk Usage by Top Tables.
The report shows that this database has 2 tables close to 700MB in size, both containing the same number of rows but there are some differences in the indexes.