Including and understanding client statistics

Client statistics collects information of query execution by considering your computer as a client. Because of this, you can see all those information and statistics which generally don't come into picture if you execute query on the same server such as, network traffic and its effect. Sometimes we feel query is running slower than what it suppose to. DBA might feel to enhance the performance of the query by a different route such as create missing index, update statistics, using proper predicate, and so on. DBA loves to see how much improvement came in performance by looking at the facts which are given in client statistics.

Getting ready

Let us create one big table which will be used in this recipe. After a creating table with thousands of row, we can check performance in client statistics and trying to improve its performance. After performance tuning, we will compare the results.

USE AdventureWorks2012
GO
--if ordDemo table is already there...