Friday, February 24, 2012

Free disk space in a cluster

Hi,

is there a way to restrict the result of xp_fixeddrives only to those drives the SQL Server cluster group has a dependency on? Or, to say more generally, how can one find out the free disk space available for remote clustered SQL Server using only TSQL?

Thanks a lot.

try:

select * from fn_servershareddrives()

or

select * from sys.dm_io_cluser_shared_drives

No comments:

Post a Comment