Technical Article

Space allocated to the databases by disk letters

,

Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently.

Note. This won't show correct information on Linux instances and if you use mounting points in Windows.

SELECT SUBSTRING(physical_name, 1, 3) DiskDrive, (8.0*sum(size))/1024/1024 GB
FROM sys.master_files
GROUP BY SUBSTRING(physical_name, 1, 3);

Rate

5 (1)

Share

Share

Rate

5 (1)