_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
|
ろ 覿一 企 襦蠏誤殊 覓朱Μ るジ ろ 豺る朱 襷 瑚. 襦蠏碁 一危磯伎り 所鍵 伎 螻朱 一願 襦蠏瑚 襷 覦覃 蟆曙 襦蠏瑚 蟾 一危磯伎り 譯殊朱 一危磯伎れ 覈螳 覦覃伎 蠏狩讌 覈詩 蟆曙磯 . 襦蠏 覲覈 殊企讌 誤蠍 伎 れ ろ襴渚碁ゼ 殊螳 襴螻 誤伎 .
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
鏤
|
蟲 覈詩 讌襷 蟲 讌 蟆 . 蠏碁 讌ろ 襴れ 覓伎螻朱 覦蠖 給. 讌 蟆語願 れ 蠍一. 覈詞朱 覿讌 蟆 讌朱 蟇伎ろる 企 蟆 螳誤 給. 螳 一渚 讌 朱 螳 襦 覈旧 覲 螻 襷 給. |