물리적 디스크 드라이브의 공간 확인 SELECT upper(volume_mount_point) as 'drive' , total_bytes/1048576/1024 as 'total_gb' , (total_bytes - available_bytes)/1048576/1024 as 'current_gb' , available_bytes/1048576/1024 as 'available_gb' , ((total_bytes - available_bytes)*1.0/total_bytes*1.0)*100 as 'usedspace' FROM master.sys.master_files AS f CROSS APPLY master.sys.dm_os_volume_stats(f.database_id, f.file_id) GROUP BY volume_mount_po.. 더보기 이전 1 2 3 4 5 6 ··· 25 다음