Use sp_monitor to see the percentage of time Adaptive Server uses the CPU during an elapsed time interval:
last_run current_run seconds
-------------------------- -------------------------- -----------
Jul 28 1999 5:25PM Jul 28 1999 5:31PM 360
cpu_busy io_busy idle
----------------------- ---------------------- -----------------
5531(359)-99% 0(0)-0% 178302(0)-0%
packets_received packets_sent packet_errors
----------------------- ---------------------- ------------------
57650(3599) 60893(7252) 0(0)
total_read total_write total_errors connections
----------------- ---------------- --------------- --------------
190284(14095) 160023(6396) 0(0) 178(1)
For more information about sp_monitor, see the Adaptive Server Enterprise Reference Manual .
