当前位置：首页 »数据库»server»io性能信息分析
[导读]
with dbio as
(
select
db_name(ivfs.database_id) as db,
case when mf.type=1 then 'log' else 'data' end as file_type,
sum(ivfs.num_of_bytes_read+ivfs.num_of_bytes_written) as io,
sum(ivfs.io_stall) as io_stall
from sys.dm_io_virtual_file_stats(null,null) as ivfs
join sys.master_files as mf
on ivfs.database_id=mf.database_id
and ivfs.file_id=mf.file_id
group by db_name(ivfs.database_id),mf.type
)
select db,file_type,
cast(1.*io/(1024*1024)as decimal(12,2)) as io_mb,
cast(io_stall/1000. as decimal(12,2)) as io_stall_s,
cast(100.*io_stall/sum(io_stall) over() as decimal(10,2)) as io_stall_pct,
row_number() over(order by io_stall desc ) as rn
from dbio
order by io_stall desc;
(
select
db_name(ivfs.database_id) as db,
case when mf.type=1 then 'log' else 'data' end as file_type,
sum(ivfs.num_of_bytes_read+ivfs.num_of_bytes_written) as io,
sum(ivfs.io_stall) as io_stall
from sys.dm_io_virtual_file_stats(null,null) as ivfs
join sys.master_files as mf
on ivfs.database_id=mf.database_id
and ivfs.file_id=mf.file_id
group by db_name(ivfs.database_id),mf.type
)
select db,file_type,
cast(1.*io/(1024*1024)as decimal(12,2)) as io_mb,
cast(io_stall/1000. as decimal(12,2)) as io_stall_s,
cast(100.*io_stall/sum(io_stall) over() as decimal(10,2)) as io_stall_pct,
row_number() over(order by io_stall desc ) as rn
from dbio
order by io_stall desc;
【免责声明：本站所发表的文章，大部分来源于各相关媒体或者网络，内容仅供参阅，与本站立场无关。如有不符合事实，或影响到您利益的文章，请及时告知，本站立即删除。谢谢监督。】
资讯搜索
数据库维护专区15851499111
推荐资讯
一、苏州数据库维护 二、苏州数据库数据恢复 三、苏州数据库数据处理 四、苏州erp系统数据维护 五、 六、 七、 八、 九、 十、..图片资讯
相关资讯
一、. 二、 三、 四、 五、 六、 七、 八、 九、 十、..The information technology professional service providers
服务热线：051265581585 15851499111 QQ:71947910 40435865