Chinaunix

标题: 请教如何知道device的剩余空间是多少? [打印本页]

作者: redwaves 时间: 2010-07-13 18:40
标题: 请教如何知道device的剩余空间是多少?
如何知道device的剩余空间是多少?
1> sp_helpdevice
2> go
device_name                   physical_name
      description
      status cntrltype device_number
      low
      high
------------------------------ ----------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      ------ --------- -------------
      --------------------------------------------------------------------------------
      --------------------------------------------------------------------------------
master                      /opt/sybase1254/data/master.dat
      special, dsync on, default disk, physical disk, 30.00 MB
            3       0          0
                                                                                    0
                                                                                 15359
sysprocsdev                   /opt/sybase1254/data/sysprocs.dat
      special, dsync on, physical disk, 132.00 MB
      16386       0          1
                                                                              16777216
                                                                              16844799
systemdbdev                   /opt/sybase1254/data/sybsysdb.dat
      special, dsync on, physical disk, 1.00 MB
      16386       0          2
                                                                              33554432
                                                                              33554943
tapedump1                   /dev/nst0
      disk, dump device
         16       2          0
                                                                                    0
                                                                                 20000
tapedump2                   /dev/nst1
      tape,       625 MB, dump device
         16       3          0
                                                                                    0
                                                                                 20000
xhb_dev                      /opt/sybase1254/data/xhb_dev.dat
      special, dsync on, physical disk, 2048.00 MB
      16386       0          3
                                                                              50331648
                                                                              51380223
xhb_log_dev                   /opt/sybase1254/data/xhb_log_dev.dat
      special, dsync on, physical disk, 2048.00 MB
      16386       0          4
                                                                              67108864
                                                                              68157439

(7 rows affected)
(return status = 0)
1> sp_helpdb
2> go
name                   db_size    owner                   dbid
      created
      status
------------------------ ------------- ------------------------ ------
      ------------------
      ------------------------------------------------------------------------------------------------------
master                         6.0 MB sa                         1
      Jul 13, 2010
      mixed log and data
model                         2.0 MB sa                         3
      Jul 13, 2010
      mixed log and data
sybsystemdb                   3.0 MB sa                      31513
      Jul 13, 2010
      mixed log and data
sybsystemprocs             132.0 MB sa                      31514
      Jul 13, 2010
      trunc log on chkpt, mixed log and data
tempdb                         3.0 MB sa                         2
      Jul 13, 2010
      select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
xhb                         240.0 MB sa                         4
      Jul 13, 2010
      no options set

(1 row affected)
(return status = 0)
1>

如上结查xhb_dev和xhb_log_dev都是2048M
而数据库xhb是240M，如何知道xhb_dev和xhb_log_dev分别的剩余空间?

作者: andkylee 时间: 2010-07-13 22:15
每个设备的未被分配空间，在ase15中执行sp_helpdevice会显示。
可以通过查看ase15的sp_helpdevice代码了解。

比如设备：xhb_dev 的low为：50331648，high值为： 51380223
查看sysusages中数据库xhb的分配情况，lstart介于low和high之间即表示xhb分配在了设备xhb_dev上，size字段表示分配的空间多少。

设备总大小减去分配的空间即为剩余空间。

作者: redwaves 时间: 2010-07-14 09:43
可不可以详细说说具体如何计算?
非常感谢

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)