{"name":"Processes in a runnable state (worker query)","description":"Acts as a simple measure of SQL Server load by measuring the number of processes that are in a runnable state.","tsql":"--Query sys.dm_os_workers to get a count of processes in a runnable state as an indicator of processor load \r\nSELECT COUNT(*)\r\nFROM sys.dm_os_workers AS dow\r\nWHERE state = 'RUNNING';","instances":true,"frequency":300,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"noalertremark":"An alert is not required","alertdescription":"","aboveorbelow":"above","collections":1,"alertenabled":false,"_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"targetentitytype":0}