Menu & Search
Disk Usage by Top Tables Report in SQL Server

Disk Usage by Top Tables Report in SQL Server


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.


Disk Usage by Top Tables Report

Right-click a database, select Reports, Standard Reports and Disk Usage by Top Tables.

Disk Usage by Top Tables SSMS

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.

Disk Usage by Top Tables Report

Share

0 Comments