# SQL Server Query to Find All Database Sizes (Data & Log) with Examples

- Link: https://techaid24.com/query-to-find-all-databases-sizes/
- Published: 2025-09-14T05:28:37+06:00
- Author: Selim Ahmed

If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage). However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query to find all databases sizes. USE master GO WITH fs AS ( SELECT database_id, type, size * 8.0 / 1024 size FROM sys.master_files ) SELECT name AS DatabaseName, (SELECT sum(size) FROM fs WHERE type = 0 AND fs.database_id = db.database_id) DataFileSizeMB, (SELECT sum(size) FROM fs WHERE type = 1 AND fs.database_id = db.database_id) LogFileSizeMB FROM sys.databases db 12345678910111213141516  USE masterGO WITH fsAS(SELECT database_id, type, size * 8.0 / 1024 sizeFROM sys.master_files)SELECTname AS DatabaseName,(SELECT sum(size) FROM fs WHERE type = 0 AND fs.database_id = db.database_id) DataFileSizeMB,(SELECT sum(size) FROM fs WHERE type = 1 AND fs.database_id = db.database_id) LogFileSizeMBFROM sys.databases db  Query to find all databases sizes, ssms union-vs-union-all