如何查看sqlserver存儲(chǔ)空間占用？

查看當(dāng)前庫(kù)里面每個(gè)表空間的占用情況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,* from sysindexeswhere indid=1order by reserved desc