Free Space on Clustered Environment

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  March 15, 2022 at 7:38 pm

  #4000186

  Hello!

  The script outputs the mounted disk information, what do I need to incorporate to get information for drives that are local to that particular node like C:\?

  SELECT DISTINCT

  volume_mount_point [Disk Mount Point],

  file_system_type [File System Type],

  logical_volume_name as [Logical Drive Name],

  CONVERT(DECIMAL(18,2),total_bytes/1073741824.0) AS [Total Size in GB], ---1GB = 1073741824 bytes

  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 %]

  FROM sys.master_files

  CROSS APPLY sys.dm_os_volume_stats(database_id, file_id)

   

   

  Thanks in advance

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  March 16, 2022 at 6:43 pm

  #4000820

  xp_fixeddrives  will get you free space.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/