[MSSQL] 데이터베이스 용량확인

데이터베이스 용량 확인

SELECT table_schema "DB명", SUM(data_length + index_length) / 1024 /1024 "size(MB)", SUM(data_free) / 1024 / 1024 "free(MB)" FROM information_schema.TABLES GROUP BY table_schema; 

테이블 별 용량 확인

SELECT
concat(table_schema,'.',table_name),
concat(round(data_length/(1024*1024*1024),2),'G') DATA,
concat(round(index_length/(1024*1024*1024),2),'G') idx,
concat(round((data_length+index_length)/(1024*1024*1024),2),'G') total_size,
round(index_length/data_length,2) idxfrac
FROM information_schema.TABLES
WHERE table_rows is not null;