O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

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. ...

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