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.
| Counter | Value | Average |
|---|---|---|
| Application Profile Statistics | ||
| Timer resolution (milliseconds) | 0 | 0 |
| Number of INSERT, UPDATE, DELETE statements | 0 | 0.222222 |
| Rows effected by INSERT, ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
