|
Comments
|
|
Interesting one.
|
|
|
Answer to question 2 is wrong! I don't think it issues accusations against the DBA. :-)
|
|
|
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.
|
|
|
Yep. I do think the quiz is a bit off on this one.
|
|
|
Is the answer for the second question right??
|
|
|
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..
|
|
|
check followup quiz question #2 - answer is wrong, and #1 i disagree with the answer given as well, but that is harder to justify.
|
|
|
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.
|
|
|
Interesting "correct" answer for question #2
|
|
|
Accusations against DBAs. I think you need to check the answers to your quiz.
|
|
|
The answer for question #2 is incorrect -- funny, but wrong...
|
|
|
Important topic.
|
|
|
Fixed the question..or the correct answer at least!
|
|
|
It would be more helpful to show how to make use of these number.
|
|
|
What is the unit of the time? milliseconds or ticks?
|
|
|
This was not what I expected, but I did learn something.
|
|
|
Very basic info.
|
|
|
A great start to using Client Statistics. Thanks
|
|
|
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
|
|
|
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.
|
|
|
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.
|
|
|
It's interesting, but it doesn't share with me how it can be helpful.
|
|
|
only just got into concept when video ended, hopefully there will be more in a future episode
|
|
|
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.
|
|
|
and what if you chose the wrong tool? you're gonna use it consistently, and get consistently useless information!
|
|
|
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.
|