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 25 2009 5:25PM         Jul 28 2009 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.