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

3 (2)

You rated this post out of 5. Change rating

Share

Share

Rate

3 (2)

You rated this post out of 5. Change rating