Query Analyzer Client Statistics

Query Analyzer also provides additional information that is related to the client-side performance of the query by toggling the Show Client Statistics option in the Query menu. When turned on, the Client Statistics tab is added to the results panel. This tab displays useful performance statistics in a tabular format that is related to how much work the client had to do to submit the query and process the results. Table 36.1 displays a representation of the Client Statistics output.

Table 36.1. Information Displayed in the Client Statistics Tab

Counter	Value	Average
Application Profile Statistics
Timer resolution ( milliseconds )
Number of INSERT, UPDATE, DELETE statements		0.222222
Rows effected by INSERT, UPDATE, DELETE statements		1
Number of SELECT statements	4	2.11111
Rows effected by SELECT statements	57000	4325
Number of user transactions	8	8.27778
Average fetch time
Cumulative fetch time
Number of fetches
Number of open statement handles
Max number of opened statement handles
Cumulative number of statement handles
Network Statistics
Number of server roundtrips	3	3
Number of TDS packets sent	3	3
Number of TDS packets received	1257	132.278
Number of bytes sent	976	402
Number of bytes received	5.12232e+006	519507
Time Statistics
Cumulative client processing time	29	18.3889
Cumulative wait time on server replies	138621	4.18096e+006

Some of the more useful pieces of information include the number of rows retrieved, the total client processing time, the time the client spent waiting for results, and the number of bytes sent and received across the network. The time values are specified in number of seconds. The values displayed in the Value column represent the statistics for the most recently run batch. The Average column contains the cumulative average since the Show Client Statistics option was enabled. Turning the option off and back on will reset the averages.