10 2013 档案

[SQL]透過redgate SQL Monitor 來找出 ASYNC_NETWORK_IO 問題
摘要：最近因為在查一個SQL的效能問題，透過sys.dm_os_wait_stats來取得Top的Wait(fromWait statistics, or please tell me where it hurts) ，如下，SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;GO--1.取得目前最高的WaitWITH [Waits] AS (SELECT [wait_type], [wait_time_ms] / 1000.0 AS [WaitS], ([wait_time_ms] - [signal_w... 阅读全文
posted @ 2013-10-19 11:46 qanholas 阅读(2488) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示