SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Download a free trial of SQL Backup now

Using Client Statistics

This video explains what client statistics are and how to use them when tuning queries.

Duration:
3 mins 42 secs
Skill Level:
100
Rating:
3.91 out of 5
Publish Date:
September 09, 2008
Using Client Statistics Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Grant Fritchey
I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

References

There are no downloads or recommended reading links for this video

Comments
Venkata Taduri on 2/24/2009
Interesting one.

Henry Smoot on 7/1/2009
Answer to question 2 is wrong! I don't think it issues accusations against the DBA. :-)

alex on 7/1/2009
excellent site, i will be checking into this site for my personal growth. You should have some type of donation button for those of us who want to thank your hard work.

Grant Fritchey on 7/1/2009
Yep. I do think the quiz is a bit off on this one.

Jim on 7/1/2009
Is the answer for the second question right??

Travis on 7/1/2009
Thanks for the info, but Client Stats don't seem all that useful to me in a real time production environment where things are changing all the time... XPlans and Profiler seem much more useful to me IMHO..

Michael Lawson on 7/1/2009
check followup quiz question #2 - answer is wrong, and #1 i disagree with the answer given as well, but that is harder to justify.

Doug on 7/1/2009
Had no idea that tool was there. I really like the questions at the end of the video. I think that helps one to analyze and integrate what they have learned. Thanks.

Phil Gainer on 7/1/2009
Interesting "correct" answer for question #2

Ross on 7/1/2009
Accusations against DBAs. I think you need to check the answers to your quiz.

Jed Perlowin on 7/1/2009
The answer for question #2 is incorrect -- funny, but wrong...

Dipak Saha on 7/2/2009
Important topic.

Andy Warren on 7/2/2009
Fixed the question..or the correct answer at least!

SH on 7/2/2009
It would be more helpful to show how to make use of these number.

Hansjörg on 7/8/2009
What is the unit of the time? milliseconds or ticks?

EE7BB68A7B on 7/10/2009
This was not what I expected, but I did learn something.

aks on 6/18/2010
Very basic info.

Jonathan on 6/18/2010
A great start to using Client Statistics. Thanks

Magnus on 6/18/2010
hanks for creating those

Mark Weichman on 6/18/2010
You never explained why the durations kept going up even when the number of rows significantly decreased

Grant Fritchey on 6/18/2010
Mark Weichman: Good point. I should have addressed it. The reason is, a new execution plan was created when I added the WHERE clause to the query. That execution plan wasn't optimal, so it was taking longer to retrieve less data. Like I said in the video, Client Statistics are interesting and can be useful, but there are problems associated with their use and it can lead to confusion.

Matt on 6/18/2010
Thanks for the video, I would really like to know more about Client Statistics and how they can be used. Also a enormous thanks on your amazing ebook. It has led me to purchase your distilled book.

Dennis Allen on 6/18/2010
Good coverage of what the information is, and how it can change, but I would like to see more on how I would use this information to draw accurate conclusions while tuning.

Leonard Peoples on 6/18/2010
It's interesting, but it doesn't share with me how it can be helpful.

Brent Templeton on 6/18/2010
only just got into concept when video ended, hopefully there will be more in a future episode

Grant Fritchey on 6/19/2010
Matt, thanks, I'm glad you found the books useful. Leonard, it's just another small tool in the toolbox that you can use when doing performance tuning.

Steve Harris on 6/22/2010
Nice to know but how would this be useful?

Charlie Bruno on 6/26/2010
I learned a new feature that I was not aware of.

Robert Djabarov on 6/27/2010
and what if you chose the wrong tool? you're gonna use it consistently, and get consistently useless information!

Grant Fritchey on 6/28/2010
Robert, yes and no. The thing is, if you only ever used this tool for performance tuning, while you might not get the most accurate information, you would always be comparing apples to apples. If your tests showed a consistent improvement in performance, that's probably because you did get a consistent improvement in performance. Serious problems start to come up when people take the numbers collected here and compare them to the numbers collected through other mechanisms like trace events of stats io. The numbers don't match, so you're seeing an apples to hammers comparison and it can lead to bad assumptions about your performance tuning.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions