Processes in a runnable state (scheduler query)

To determine the general load on the operating system you can get a count of the processes that are in a runnable state.

Install metric...

Metrics install automatically if you have SQL Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.

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), 2.5 out of 5 based on 6 ratings

Metric definition

Name

Processes in a runnable state (scheduler query)

Description

Shows the number of active processes in the Windows OS.

The T-SQL query that will collect data

Instances to collect from

Select all

Databases to collect from

master

Collection frequency

300

Use collected or calculated values

Leave the Use a calculated rate of change between collections check box unchecked

Metric collection

Enabled

Alert definition

An alert is not required