Find SQL Server Database Data and Log File Size in GB

SELECT DB_NAME([database_id])AS [Database Name],

[file_id], name, physical_name, type_desc, state_desc,

CONVERT( bigint, size/128000.0) AS [Total Size in GB]

FROM sys.master_files

ORDER BY DB_NAME([database_id]) OPTION (RECOMPILE);

-- Things to look at:

-- Are data files and log files on different drives?

-- Is everything on the C: drive?

-- Is TempDB on dedicated drives?

-- Is there only one TempDB data file?

-- Are all of the TempDB data files the same size?

-- Are there multiple data files for user databases?