ASE : Display Available Device Space - Free Disk Space
来源:互联网 发布:腾讯java工程师面试题 编辑:程序博客网 时间:2024/04/25 16:24
ASE : Display Available Device Space - Free Disk Space
Determining the amount of free space on a server's set of devices
is not an easy task; the procedure below produces a nice report,
showing total allocations and available space on each device.
Thanks to Stephanie L for this example.
create procedure sp_freedisk
as
set nocount on
select
logical_name = substring(d.name, 1, 12),
physical_name = substring(d.phyname, 1, 17),
vdevno = d.low / power(2, 24),
size = (d.high - d.low + 1) * 2 / 1024,
reserved = isnull(sum(u.size) * 2 / 1024, 0),
left = (d.high - d.low + 1) * 2 / 1024 -
isnull(sum(u.size) * 2 / 1024, 0)
from
master.dbo.sysdevices d, master.dbo.sysusages u
where
d.status & 2 = 2
and u.vstart / power(2, 24)=*d.low / power(2, 24)
group by
substring(d.name, 1, 12),
substring(d.phyname, 1, 17),
d.low / power(2, 24),
(d.high - d.low + 1) * 2 / 1024
order by vdevno
return
is not an easy task; the procedure below produces a nice report,
showing total allocations and available space on each device.
Thanks to Stephanie L for this example.
create procedure sp_freedisk
as
set nocount on
select
logical_name = substring(d.name, 1, 12),
physical_name = substring(d.phyname, 1, 17),
vdevno = d.low / power(2, 24),
size = (d.high - d.low + 1) * 2 / 1024,
reserved = isnull(sum(u.size) * 2 / 1024, 0),
left = (d.high - d.low + 1) * 2 / 1024 -
isnull(sum(u.size) * 2 / 1024, 0)
from
master.dbo.sysdevices d, master.dbo.sysusages u
where
d.status & 2 = 2
and u.vstart / power(2, 24)=*d.low / power(2, 24)
group by
substring(d.name, 1, 12),
substring(d.phyname, 1, 17),
d.low / power(2, 24),
(d.high - d.low + 1) * 2 / 1024
order by vdevno
return
- ASE : Display Available Device Space - Free Disk Space
- ubuntu更新Not enough free disk space
- Ubuntu --- not enough free disk space
- SCOM "Logical Disk Free Space" Monitor
- ubuntu更新时"Not enough free disk space"
- 7 Ways To Free Up Hard Disk Space On Windows
- ubuntu更新时"Not enough free disk space"
- Insufficient free space: 25 extents needed, but only 0 available
- ASE :Space available in segment 'logsegment' has fallen critically low in database
- Excessive Disk Space
- Linux disk space analysis
- vmware disk space
- No buffer space available
- No buffer space available
- no buffer space available
- free space of Windows
- no space left device
- Datastore Provisioned Space vs Free Space
- sass学习——SassScript
- 戴尔私有化新变数:伊坎黑石加入导致三方竞购
- 黑马程序员—Set接口
- LINUX系统性能调谐
- sql server脚本笔记
- ASE : Display Available Device Space - Free Disk Space
- ioctl的相关理解
- cocos2d-x屏幕适配 三个参数含义
- startActivityForResult ,onActivityResult,Activity之间传数据
- 乱码问题
- Android编程之另一种原因造成Cursor未关闭错误
- 10个重要的算法C语言实现源代码
- WinRT 介绍
- Unity Tweak Tool:MyUnity