To determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.
Processes in a runnable state (scheduler query)
Shows the number of active processes in the Windows OS.
The T-SQL query that will collect data
Instances to collect from
Databases to collect from
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
An alert is not required