Evaluation tools with Adaptive Server

The sp_monitor system procedure reports on packet activity. This report shows only the packet-related output:

...
packets received packets sent packet err
---------------- ------------ ----------
10866(10580)     19991(19748) 0(0)
...

You can also use these global variables:

These SQL statements show how the counters can be used:

select "before" = @@pack_sent
select * from titles
select "after" = @@pack_sent

Both sp_monitor and the global variables report all packet activity for all users since the last restart of Adaptive Server.

See the Performance and Tuning Guide: Tools for Performance Statistics book for more information about sp_monitor and these global variables.