Using sp_monitor to measure CPU usage

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 .