sybase查看数据库使用空间在sybasea数据库中,可以使用命令
sp_helpsegment 命令来获取数据库的使用情况,
也可以通过SELECT语句来获取数据库的使用情况,
select @@maxpagesize 数据库页大小,这里以每页为8K的数据库为例:
查看数据库使用情况
select convert(varchar(20),round((sum(u.size)*8/1024.0),0))+"MB",
convert(varchar(20),round(sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB',
convert(varchar(20),round(sum(u.size)*8/1024.0-sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB'
from master.dbo.sysusages u,master.dbo.sysdevices d
where u.segmap&2 = 2
and u.dbid = db_id()
and d.status&2 = 2
and d.low <= u.vstart
and d.high >= u.vstart + (u.size - 1)
查看数据库日志使用情况
select "=log_tot"+convert(varchar(20),round((sum(u.size)*8/1024.0),0))+"MB",
convert(varchar(20),round(sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB',
convert(varchar(20),round(sum(u.size)*8/1024.0-sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB'
from master.dbo.sysusages u,master.dbo.sysdevices d
where u.segmap&4 = 4
and u.dbid = db_id()
and d.status&2 = 2
and d.low <= u.vstart
and d.high >= u.vstart + (u.size - 1)
sp_helpsegment 命令来获取数据库的使用情况,
也可以通过SELECT语句来获取数据库的使用情况,
select @@maxpagesize 数据库页大小,这里以每页为8K的数据库为例:
查看数据库使用情况
select convert(varchar(20),round((sum(u.size)*8/1024.0),0))+"MB",
convert(varchar(20),round(sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB',
convert(varchar(20),round(sum(u.size)*8/1024.0-sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB'
from master.dbo.sysusages u,master.dbo.sysdevices d
where u.segmap&2 = 2
and u.dbid = db_id()
and d.status&2 = 2
and d.low <= u.vstart
and d.high >= u.vstart + (u.size - 1)
查看数据库日志使用情况
select "=log_tot"+convert(varchar(20),round((sum(u.size)*8/1024.0),0))+"MB",
convert(varchar(20),round(sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB',
convert(varchar(20),round(sum(u.size)*8/1024.0-sum(curunreservedpgs(db_id(),u.lstart,u.unreservedpgs)*8/1024.0),0))+'MB'
from master.dbo.sysusages u,master.dbo.sysdevices d
where u.segmap&4 = 4
and u.dbid = db_id()
and d.status&2 = 2
and d.low <= u.vstart
and d.high >= u.vstart + (u.size - 1)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22661144/viewspace-1430699/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22661144/viewspace-1430699/