DB테이블별 용량확인
Tip & Tech / 2015. 9. 8. 11:41
-- MSSQL DB테이블별 용량확인
SELECT CONVERT(VARCHAR(100), MIN(o.name)) AS t_name, i.rows
, LTRIM(STR(SUM(reserved) * 8192.0 / 1024.0 / 1024.0 , 15, 0) + ' MB') AS t_size
FROM sysindexes i
INNER JOIN sysobjects o ON o.id = i.id
WHERE i.indid IN (0, 1, 255)
AND o.xtype = 'U'
GROUP BY
i.id, i.rows
ORDER BY
SUM(reserved) * 8192.0 / 1024.0 DESC