1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| select top 10
o.name as table_name,
i.name as index_name,
sum(p.rows) as total_rows,
sum(a.total_pages) as total_pages,
sum(a.used_pages) as used_pages,
sum(a.total_pages) / 128 as total_size_mb,
sum(a.used_pages) / 128 as used_size_mb
from sys.partitions as p
join sys.allocation_units as a
on p.hobt_id = a.container_id
join sys.objects as o
on o.object_id = p.object_id
join sys.indexes as i
on i.object_id = p.object_id
and i.index_id = p.index_id
group by o.name, i.name
order by total_pages desc |
