{"name":"WriteLog Wait Time (ms per sec)","description":"Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits.\r\nMetric shows the wait time (in ms) per elapsed second.\r\nFor more information, see <a href=\"http:\/\/blogs.msdn.com\/b\/sqlsakthi\/archive\/2011\/04\/17\/what-is-writelog-waittype-and-how-to-troubleshoot-and-fix-this-wait-in-sql-server.aspx\">http:\/\/blogs.msdn.com\/b\/sqlsakthi\/archive\/2011\/04\/17\/what-is-writelog-waittype-and-how-to-troubleshoot-and-fix-this-wait-in-sql-server.aspx<\/a>.","tsql":"SELECT wait_time_ms\r\nFROM  sys.dm_os_wait_stats\r\nWHERE wait_type = 'WRITELOG'","instances":true,"frequency":60,"databases":{"mode":0},"rateofchange":true,"metricenabled":true,"alertname":"WriteLog wait time too high","alertdescription":"The WriteLog wait time is too high. This can occur while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits.","aboveorbelow":"above","collections":3,"alertenabled":true,"_thresholds_high":{"selected":true,"value":800},"_thresholds_medium":{"selected":true,"value":500},"_thresholds_low":{"selected":true,"value":100},"thresholds_comment":"Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.","targetentitytype":0}