Export (0) Print
Expand All

Query Window Statistics Pane

SQL Server 2000

The Show Client Statistics command provides detailed information about client-side statistics for execution of the query. The output result set displayed in the Statistics pane contains these columns.

Column name Description
Counter Counter label.
Value The value of the counter, updated after each query execution .
Average A running average from the beginning of the connection or since the last manual reset.

The three groups of statistics counters are:

  • Application profile

  • Network

  • Time

These statistics are displayed only when query results are generated. They are not displayed when commands such as Parse, Display Estimated Execution Plan, or Index Tuning Wizard are selected.

Application Profile Statistics
Counter Description
Timer Resolution (milliseconds) Minimum resolution of the server clock time in milliseconds. This is usually reported as zero and should only be considered if the number reported is large. If the minimum resolution of the server clock is larger than the likely interval for some of the timer-based statistics, those statistics could be inflated.
Number of INSERT, UPDATE, DELETE statements Number of INSERT, UPDATE, or DELETE statements after SQL_PERF_START.
Rows affected by INSERT, UPDATE, DELETE statements Number of rows affected by INSERT, UPDATE, or DELETE statements after SQL_PERF_START.
Number of SELECT statements Number of SELECT statements processed after SQL_PERF_START.
Rows affected by SELECT statements Number of rows selected after SQL_PERF_START.
Number of user transactions Number of user transactions after SQL_PERF_START, including rollbacks. When an ODBC application is running with SQL_AUTOCOMMIT_ON, each command is considered a transaction.
Average fetch time Equals SQLFetchTime/SQLFetchCount.
Cumulative fetch time Cumulative amount of time it took to complete fetches against server cursors.
Number of fetches Number of fetches performed against server cursors after SQL_PERF_START.
Number of open statement handles Number of statement handles currently open on all connections open in the driver.
Max number of open statement handles Maximum number of concurrently opened statement handles after SQL_PERF_START.
Cumulative number of statement handles Number of statement handles opened after SQL_PERF_START.

Network Statistics
Counter Description
Number of server roundtrips Number of times the driver sent commands to the server and received a reply.
Number of TDS packets sent Number of TDS packets sent to SQL Server by the driver after SQL_PERF_START. Large commands can take multiple buffers. For example, if a large command is sent to the server and it fills six packets, ServerRndTrips is incremented by one and BuffersSent is incremented by six.
Number of TDS packets received Number of TDS packets received by the driver from SQL Server after the application started using the driver.
Number of bytes sent Number of bytes of data sent to SQL Server in TDS packets after the application started using the driver.
Number of bytes received Number of bytes of data in TDS packets received by the driver from SQL Server after the application started using the driver.

Time Statistics
Counter Description
Cumulative client processing time Cumulative amount of time the driver spent processing after SQL_PERF_START, including the time it spent waiting for replies from the server.
Cumulative wait time on server replies Cumulative amount of time the driver spent waiting for replies from the server.

Show:
© 2014 Microsoft