How Do I See Total Disk Space In SQL Server?

How Do I See Total Disk Space In SQL Server? SELECT DB_NAME() AS DbName, name AS FileName, size/128.0 AS CurrentSizeMB, size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS INT)/128.0 AS FreeSpaceMB. FROM sys. database_files. WHERE type IN (0,1); How do I find the size of a SQL database? If you need to check a single database, you can