如何用命令查询segment和设备对应关系

highsea8918

如题，
比如seg_testindex 对应设备testidx.dat等

[ 本帖最后由 highsea8918 于 2008-11-17 23:46 编辑 ]

chenfeng825

declare @unit int
select @unit=1048576/@@maxpagesize
select  sum(u.size)/@unit total_size
        ,sum(curunreservedpgs(db_id(),u.lstart, u.unreservedpgs))/@unit free_size
        ,(sum(u.size)/@unit)-(sum(curunreservedpgs(db_id(),u.lstart, u.unreservedpgs))/@unit) as used_size
        , s.name,d.name
       from master.dbo.sysusages u ,syssegments s,master..sysdevices d where u.dbid = db_id()  and power (2,s.segment) & u.segmap > 0
         and d.low = u.vstart
  group by u.segmap,s.name,d.name