用什么命令可以显示数据库的剩余空间

earthman

免费乐捐，感谢支持

用什么命令可以显示数据库的剩余空间

JohnPhan

sp_helpdb <your_database_name>

jensen

select s.name, (select max(convert(int,t.status & 1)) from zbtest.dbo.
systhresholds t where s.segment=t.segment) status, sum(u.size) size, sum(u.size
- curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs)) used, @@thresh_hysteresis
hysteresis from zbtest.dbo.syssegments s, master.dbo.sysusages u where 1 = 1 and
((u.segmap / ((s.segment & 1) + 1)) / power(2, (s.segment & 30))) & 1 = 1 and u.
dbid = db_id('zbtest') and s.name like '%' group by s.name order by 1

将zbtest 换成你的数据库名

yj0714

sp_spaceused

msp23

up