What are the Statistics IO?

This video explains with the statistics IO are and how to use them for performance tuning.

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.

Ed Svastits on 3/12/2009

Fine. Could have gone into more depth for interpreting the io output.

Paul on 3/12/2009

Information I can use immediately on the job presented in a clear, concise form. Thank you!

Dick Rosenberg on 3/12/2009

Would have liked more explanation on what to do with the information

380A492120 on 3/12/2009

Excellent, very Cool.. I have been looking for this for years. Thank you very much Grant!

Sara Karasik on 3/12/2009

this was the perfect length. I love this format; one short lesson, one complete lesson, and useful tips.

Mohammad Norouzi on 3/12/2009

It would be good if the video explained what are the information we receive fron the statistics and how to explain that.

James Lim on 3/12/2009

This is a good information about the options to turn on statistics I/O and time. I would probably use this on a case by case basis in production though.

Denise Yu on 3/12/2009

That's so cool and efficient way to do the tuning performance. Would be nice if can give a little more indepth of logical reads 607 pages, for example, that how it will recomment or change my query to be runing for better.

Grant Fritchey on 3/13/2009

I'm glad this was useful for those who found it so. The goal of the video was to show how to gather the information and that's all. Showing what to do with it would require a lot more time and a lot more examples. Suffice to say, get this information, identify the tables with the most scans or the most pages read, adjust the query structure or indexes and then regather the information to compare before and after.

Lars Rasmussen on 3/17/2009

Question 1 indicates STATISTICS ON where you probably mean STATISTICS IO ON.

Peter Schofield on 3/20/2009

Grant mentions milli-seconds in the video, but SQL2005 and later times in micro-seconds...

Grant Fritchey on 3/22/2009

Actually, at least according to BOL, STATISTICS TIME is still showing milliseconds. Micro-seconds is definitely the value recorded in trace events. http://msdn.microsoft.com/en-us/library/ms190287.aspx. But it wouldn't be the first time BOL is off.

Tonci on 12/10/2009

Great! Thank you.

aks on 1/9/2010

Excellent. Didnt know this. Can be very useful. And so easy to use.

Keith Badeau on 5/30/2011

Great video. Simple and to the point. Thank you.

Dick Rosenberg on 8/8/2011

Nice presentation about how to turn the statistics on/off, but what do you do with the information?

John O'Sullivan on 8/8/2011

excellent video tip

Tahir A. Syed on 8/8/2011

marvelous! thanks...Tahir

dfortier on 8/8/2011

Good to know info! Thanks.

Omair on 8/8/2011

I already knew about these options. I gave it a 3 because Grant did not elaborate further between the difference of Logical versus Physical reads. However, he for some reason, decided to ask a question int he survey after the video which he never explained in the video.

Tom Hamilton on 8/8/2011

Very helpful - please show more on performance evaluation and tuning

john on 8/8/2011

great info ... quickly!

abdulwalele on 8/8/2011

The voice is rather too low... you need to set your voice a little bit louder. Otherwise, it is a great knowledge transfer.

Mat on 8/8/2011

I just love these tips

Kevin Bayer on 8/9/2011

Good video...thank you...

Abdul Rauf on 8/10/2011

Good

Guido Perez on 8/11/2011

I really like the quiz pop-up

Dallas on 8/15/2011

good info! thanks a lot :)

Kasey Wheeler on 8/17/2011

Nice video.

Maurice Ivory on 1/9/2012

This is good stuff to know.