{"name":"OS Wait Time: CXPACKET","description":"CXPACKET waits indicate coordination of multiple threads from queries that have been parallelized and one or more of the subtasks have completed before others. These waits may or may not be an issue, but on an OLTP system, high CXPACKET waits may indicate too many complex queries needing parallel operations. Long wait times captured by this metric may indicate queries that are taking a long time to complete, even using parallel query plans.\r\nNote: Values are calculated\/accumulated since the last restart of the server, or if they are reset using: DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);","tsql":"SELECT  wait_time_ms \/ 1000.0 AS wait_time_sec\r\nFROM    sys.dm_os_wait_stats \r\nWHERE   wait_type = 'CXPACKET';","instances":true,"frequency":600,"databases":{"mode":1},"rateofchange":true,"metricenabled":true,"noalertremark":"You could add an alert once the baseline for your environment has been established, and you have a better idea of what thresholds to set.","alertdescription":"Alert description goes here","aboveorbelow":"above","collections":3,"alertenabled":true,"_thresholds_high":{"selected":true,"value":800},"_thresholds_medium":{"selected":true,"value":500},"_thresholds_low":{"selected":true,"value":100},"targetentitytype":0}