Uses the runnable task averages from the monSysLoad monitoring table to provide 1-, 5-, and 15-minute averages of runnable tasks. All running (and runnable) tasks on engines are included in this average. The minute intervals are fixed and do not vary with your configured sp_sysmon sample time.
The number of runnable tasks provides an excellent way to measure how busy Adaptive Server is. For example, a server with an average “Engine Utilization” of 90% and a high number of runnable tasks is more likely to benefit from additional engines than a server with an average of 90% and a low number of runnable tasks.
Comparing the 1, 5, and 15 minute samples can help you determine if the load on the server is increasing, remaining stable, or decreasing.
