1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
select "name" = @@servername+"."+db_name()+"."+o.name,
"lockrow" = case when ((sysstat2 & 49152) = 0) then "allpages"
when ((sysstat2 & 32768) > 0) then "datarows"
else "datapages" end,
"rowtotal" = convert(numeric(10,0),sum(rowcnt(i.doampg))),
"reserved" = convert(numeric(10,0),sum(convert(numeric(32, 9), (reserved_pgs(i.id, i.doampg) + reserved_pgs(i.id, i.ioampg))) * (low / 1024))),
"data_size" = convert(numeric(10,0),sum(convert(numeric(32, 9), data_pgs(i.id, i.doampg)) * (low / 1024))),
"index_size" = convert(numeric(10,0),sum(convert(numeric(32, 9), data_pgs(i.id, i.ioampg)) * (low / 1024))),
"unused" = convert(numeric(10,0),sum(convert(numeric(32, 9), ((reserved_pgs(i.id, i.doampg) + reserved_pgs(i.id, i.ioampg)) - (data_pgs(i.id, i.doampg) + data_pgs(i.id, i.ioampg)))) * (low / 1024)))
from master.dbo.spt_values d,
sysobjects o,
sysindexes i
where o.type in ('U', 'S')
and o.id = i.id
and d.number = 1
and d.type = "E"
group by o.id
order by 4 desc |
Partager