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 you can use these counters:
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 Chapter 14 “Using Batches and Control-of-Flow Language,” in the Transact-SQL Users Guide for more information about sp_monitor and these global variables.
