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.
Counter | Value | Average |
---|---|---|
Application Profile Statistics | ||
Timer resolution (milliseconds) | 0 | 0 |
Number of INSERT, UPDATE, DELETE statements | 0 | 0.222222 |
Rows effected by INSERT, UPDATE, DELETE statements | 0 | 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 | 0 | 0 |
Cumulative fetch time | 0 | 0 |
Number of fetches | 0 | 0 |
Number of open statement handles | 0 | 0 |
Max number of opened statement handles | 0 | 0 |
Cumulative number of statement handles | 0 | 0 |
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.