O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SSMS Client Statistics

You can use SSMS to get some additional information related to the client-side performance of the query by toggling the Include 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, including statistics about the network packets and elapsed time of the query.

SSMS keeps track of the statistics for previous executions within a session so that you can compare the statistics between different query executions. It also keeps track of the overall average statistics across all executions. Figure 32.13 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required