SQL Server: Get All Databases Size

aasim abdullah

4.43/5 (5 votes)

2 Oct 2012CPOL

104.2K

A simple query to get all databases size on a given instance.

Introduction

To get recent size of all databases on an instance, I have found following simple query very useful.

Script

SQL

SELECT d.name,
ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs
FROM sys.master_files mf
INNER JOIN sys.databases d ON d.database_id = mf.database_id
WHERE d.database_id > 4 -- Skip system databases
GROUP BY d.name
ORDER BY d.name

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)