{"name":"Available Worker Threads","description":"Metric checking available worker threads on Availability Groups","tsql":"DECLARE @max INT;\r\nSELECT  @max = max_workers_count\r\nFROM    sys.dm_os_sys_info;\r\n\r\nSELECT  @max - SUM (active_workers_count) AS [AvailableThreads]\r\nFROM    sys.dm_os_schedulers\r\nWHERE   status = 'VISIBLE ONLINE';\r\n","instances":false,"databases":{"mode":1},"frequency":60,"metricenabled":true,"noalertremark":"N\/A","frequency_comment":"seconds (collected every minute)","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}