SQL Server 数据表大小，磁盘空间

查看数据库大小

exec sp_spaceused '表名'

查看每张表数据大小

exec sp_MSforeachtable 'exec sp_spaceused'

create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20))
exec sp_MSforeachtable 'insert into #t exec sp_spaceused ''?'''
select * from #t order by rows
drop table #t

 

select id,object_name(id) as tableName,indid,rows,rowcnt 
from sys.sysindexes
where indid in(0,1)
order by rows

 

查询服务器磁盘可用空间

xp_fixeddrives