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:
@@pack_sent – Number of packets sent by Adaptive Server
@@pack_received – Number of packets received
@@packet_errors – Number of errors
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.
