Get Volume statistics (Storage Partition)

Returns information about the operating system volume (directory) on which the specified databases and files are stored in SQL Server. Use this dynamic management function to check the attributes of the physical disk drive or return available free space information about the directory. sys.dm_os_volume_stats (Transact-SQL)