ms-sql 테이블별 용량 size 크기 확인 쿼리

select top 10

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