{"name":"Tempdb allocation contention","description":"This metric can help identify whether you have contention on tempdb allocation by measuring pagelatch waits. \r\n","tsql":"SELECT  COUNT(*) AS cnt\r\nFROM    sys.dm_os_waiting_tasks a\r\nWHERE   a.wait_type LIKE 'PAGE%LATCH_%'\r\n        AND a.resource_description LIKE '2:%';\r\n","instances":true,"frequency":60,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"alertname":"Tempdb allocation contention","alertdescription":"This alert is raised when the number of pagelatch waits on the tempdb database increases to match the alert thresholds.","aboveorbelow":"above","collections":1,"alertenabled":true,"_thresholds_high":{"selected":true,"value":50},"_thresholds_medium":{"selected":true,"value":10},"_thresholds_low":{"selected":true,"value":0},"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}