统计Wait_Queue
摘要：functionfunhelp(){$helpText=@"NAME:Collect_dm_os_wait_stats.ps1ThisscriptCollectWaitandQueueinformationfromDMVsys.dm_os_wait_statsThisisahardcodescript,youdon'tneedtospecifyanyparameter.Pleasemodify'computerList'ifyouwanttoaddmorecomputers..MakesureyouhaveaDisk_databaseinthehostwher
阅读全文
posted @
2011-03-28 16:35
stswordman
阅读(391)
推荐(0) 编辑
各个数据库的io比例
摘要：select case df.database_id when DB_ID('distribution') then 'distDB' when DB_ID('tempdb') then 'tempdb' --add other needed database else 'otherDBs' end as dbName, case df.type when 0 then 'datafile' when 1 then 'logfile' else 'otherfile'
阅读全文
posted @
2011-03-27 23:00
stswordman
阅读(522)
推荐(0) 编辑
