Author:

Author Bio:

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.

Using Client Statistics

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

Video Information
Publish Date:	September 09, 2008
Length:	3:42
Skill Level:	100
Rating:	3.86 out of 5

After watching you should be able to answer these questions:

Which should you use for tuning, Profiler or client statistics?

What does the 'trial' feature of client statistics do?

You must be logged in to view this video.

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

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.


Must Be Logged In

References