_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPageろろ譯殊姶蟲蠍 › TempdbAndTransactionLogIOLatencies

http://www.sqlskills.com/blogs/paul/survey-tempdb-and-transaction-log-io-latencies/?utm_source=feedly
SELECT
	[database_id],
	[file_id],
    [ReadLatency] =
		CASE WHEN [num_of_reads] = 0
			THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END,
	[WriteLatency] =
		CASE WHEN [num_of_writes] = 0
			THEN 0 ELSE ([io_stall_write_ms] / [num_of_writes]) END
FROM
	sys.dm_io_virtual_file_stats (NULL, NULL)
WHERE
	[file_id] = 2 OR [database_id] = 2;
GO
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

殊 煙隈 螻旧 朱 企. 螻旧 願屋 螻旧 螳讌 螻 螻旧 蠏瑚 願屋朱 瑚 覿 覓語願鍵 覓語企. 磯殊 磯Μ れ朱 企蟆 襷 . 螻 覓語 豢覲旧 覦り. (蟾蟯 リ啓 螳 蠖譴)