The databases by size report is a quick and easy way to see which databases on your SQL Server are the largest. The chart shows the top 16 databases by size, and the grid at the bottom of the page shows all the databases on your SQL Server.
The grid includes the following:
- Name of the databases.
- Disk space taken up by data, and indexes (Rows column).
- The size of the transaction log.
- The amount of space taken up by File Stream
- Text indexes
- and finally the overall size or total amount of disk space for the entire database.
You can get to this report by going to the Server Overview page and clicking the chart that shows the largest databases by size.