SQL Snippet – list all databases with size

5.00 / 5 5
1 / 5
2 / 5
3 / 5
4 / 5
5 / 5

1 vote, 5.00 avg. rating (94% score)

SQL – Get the list of all the databases and their size

The below script will give the list of all database with name and size of respective database

 SELECT d.name [DB Name],
 ROUND(SUM(mf.size) * 8 / 1024, 0) [DB Size (Mb)] 
FROM sys.master_files mf 
INNER JOIN sys.databases d ON d.database_id = mf.database_id
 WHERE d.database_id > 4 -- avoid system databases 
GROUP BY d.name ORDER BY [DB Size (Mb)] desc