Did you try this ?
SELECT distinct
vs.volume_mount_point
, vs.volume_id
, vs.logical_volume_name
, vs.file_system_type
, vs.total_bytes / 1048576 AS 'MBTotal'
, vs.available_bytes / 1048576 AS 'MBAvailable'
, CAST( 1.00 * vs.available_bytes / vs.total_bytes * 100 as decimal(5,2) ) as pctFree
, vs.supports_compression
, vs.supports_alternate_streams
, vs.supports_sparse_files
, vs.is_read_only
, vs.is_compressed
FROM [sys].[master_files] AS f
CROSS APPLY [sys].[dm_os_volume_stats]([f].[database_id], [f].[file_id]) AS vs
ORDER BY [vs].[logical_volume_name] ;
Of course, this will only provide information about drives to which the sqlinstance has databases allocated.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me