Space usage on MSSQL
See how you can quickly get a Disk usage report in SQL Server Management Studio that shows database size, used and unused space.
How to view disk usage on your MSSQL‑database
To see how much space you have used on your MSSQL database, right‑click your database in SQL Management Studio and select "Reports", then "Standard Reports", and choose "Disk usage".
-
Open SQL Server Management Studio (SSMS)
Launch the programme and log onto the server where your database resides. -
Find your database in Object Explorer
In the left‑hand pane (Object Explorer) expand the server’s tree until you can see the list of databases. -
Right‑click the desired database
-
Select “Reports” → “Standard Reports”
-
Click “Disk usage”
The report opens in a new window and shows a detailed overview of the used and available space.
What does the “Disk usage” report show?
| Column | Description |
|---|---|
| Database size (MB) | The total size of the database including data and log files. |
| Space used (MB) | How much of the total size is actually in use. |
| Unused space (MB) | How much space is allocated but not yet used. |
| Data file(s) | Details for each data file (*.mdf, .ndf). |
| Log file(s) | Details for the log file (.ldf). |
Article from the support category: Microsoft SQL Server
