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. ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
