You can add a site-specific metric to the workload measurement algorithm using the workload_metric built-in function. In a typical example, you might monitor response time using an external monitor, and then insert the response-time values into the algorithm.
Adaptive Server normalizes system-supplied metrics before including them in the workload algorithm. For compatibility, you must normalize the user-supplied metric as well. For example, if the maximum acceptable response time is 5 seconds and the measured response time is 2 seconds, the normalized value is 40 (2 is 40% of 5), which can be entered into the workload algorithm using workload_metric.
.
