Action

Busy servers typically have high values for Waits. However, high values for WaitTime or the time slice setting may indicate that Adaptive Server has a large number of spids waiting to execute, or that is has spids running which were heavily CPU bound and are not readily yielding their CPU. Query monProcessActivity to identify jobs that have high CPUTime.