Adaptive Server evaluation tools

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

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

You can also use these global variables:

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.