_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 襦蠏誤殊蟆渚

Contents



ろ 覿一 企 襦蠏誤殊 覓朱Μ るジ ろ 豺る朱 襷 瑚. 襦蠏碁 一危磯伎り 所鍵 伎 螻朱 一願 襦蠏瑚 襷 覦覃 蟆曙 襦蠏瑚 蟾 一危磯伎り 譯殊朱 一危磯伎れ 覈螳 覦覃伎 蠏狩讌 覈詩 蟆曙磯 . 襦蠏 覲覈 殊企讌 誤蠍 伎 れ ろ襴渚碁ゼ 殊螳 襴螻 誤伎 .

DBCC sqlperf(waitstats,clear) -- wait statistics 企Μ
drop table waitstats
create table waitstats (Wait_Type varchar(80), 
                           Requests numeric(18,1),
                           Wait_Time numeric (18,1),
                           Signal_Wait_Time numeric(18,1),
                           timenow datetime default getdate())
declare @start int, @finish int
select @start = 1, @finish = 10
while (@start < @finish)
begin
             Begin transaction
                     insert into waitstats (Wait_Type, Requests, 
                           Wait_Time,Signal_Wait_Time)
                           exec ('DBCC sqlperf(waitstats)')
             commit
 
             select @start = @start + 1
             waitfor delay '00:00:10'        -- 10豐 螳蟆朱 
End
 
--殊螳 讌  
Select * FROM WAITSTATS order by wait_time desc
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

覦 一企 レ 襷 覦覯 れ 蠏瑚 覦 . (蟯危)