How to check free disk space for mount points in SQL Server

Question: I have some SQL Servers and the  file system is organised with mount points. SQL Server is configured to distribute the system files , data , transaction log and tempdb files on those mountpints. As these are Production systems - the DBA does not have permanent access to the Disak Manager without a request for elevated privileges. But they do have privileges to execute administration type of queries. 

Do you have a query that allows the DBA to excute a query to determine the Total Size , Available Size and Space Free on the mountpoints 

Answer:  This is a common requirement based on standard privileges  for Production systems.  This is a query I use - courtesy of Glen Berry .   I've made some minir adjustments to suit my requirements . As a minimum you'll require privileges to  view sys.dm_os_volume_stats , sys.master_files

SELECT DISTINCT vs.volume_mount_point  collate sql_latin1_general_cp1_ci_as, vs.file_system_type,
vs.logical_volume_name, CONVERT(DECIMAL(18,2),vs.total_bytes/1073741824.0) AS [Total Size (GB)],
CONVERT(DECIMAL(18,2),vs.available_bytes/1073741824.0) AS [Available Size (GB)],
CAST(CAST(vs.available_bytes AS FLOAT)/ CAST(vs.total_bytes AS FLOAT) AS DECIMAL(18,2)) * 100 AS [Space Free %]
FROM sys.master_files AS f WITH (NOLOCK)
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.[file_id]) AS vs
ORDER BY 1 OPTION (RECOMPILE);

If you prefer using Powershell - read Get free disk space for mount points using Powershell