select object_name(id) tablename,
8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used,
8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free,
rows,rowcnt from sysindexes
where indid=1
8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used,
8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free,
rows,rowcnt from sysindexes
where indid=1
order by reserved desc
可以监控某一个库的数据变化,很有用的,特别是对和某个系统兼容的情况。