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) 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.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features