info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



Get Disk Database Files Mount Points
by BF (Principal Consultant; Architecture; Engineering)
2022-12-04








Get Disk Database Mount Points:


SELECT
DISTINCT
@@ServerName [Server],
SUBSTRING(volume_mount_point,1,3) [Disk],
file_system_type [File System Type],
CONVERT(DECIMAL(18,2),total_bytes/1073741824.0) AS [Total Size in GB],
CONVERT(DECIMAL(18,2),available_bytes/1073741824.0) AS [Available Size in GB],
CAST(CAST(available_bytes AS FLOAT)/ CAST(total_bytes AS FLOAT) AS DECIMAL(18,2)) * 100 AS [Space Free %],
GETDATE() [DateTmeStamp]
FROM sys.master_files
CROSS APPLY sys.dm_os_volume_stats(database_id, file_id)