[MSSQL] Table 별 용량 확인 Query

 

 

select top 20
        table_name = convert(varchar(30), min(o.name)),
        table_size = convert(int, ltrim(str(sum(reserved) * 8.192 / 1024., 15, 0))), UNIT = 'MB'
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
order by 2 desc