Home Forums SQL Server 2008 SQL Server 2008 - General How can I find the Total free memory in the windows machine where a sqlserver instances are installed? RE: How can I find the Total free memory in the windows machine where a sqlserver instances are installed?

  • July 12, 2013 at 5:44 pm

    #1632156

    SELECT distinct volume_mount_point

    ,cast(available_bytes as decimal)/1073741824 as [Space_in_GB]

    FROM sys.master_files AS f

    CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id)

    from http://connect.microsoft.com/SQLServer/feedback/details/642004/denali-xp-fixeddrives-does-not-display-mounted-volume-information-on-a-cluster