Using the DTA to Assist in Performance Tuning

This video shows you how to use the Database Tuning Analyzer (DTA) in SQL Server to help you make performance based changes to your database - especially helpful when you haven't quite mastered reading execution plans and you have a query that is performing badly.

Jonathan Kehayias is currently employed as a Principal Consultant and Trainer for SQLskills, one of the best-known and most respected SQL Server training and consulting companies in the world. Jonathan is a SQL Server MVP and one of the few Microsoft Certified Masters for SQL Server 2008, outside of Microsoft. Jonathan frequently blogs about SQL Server, presents sessions at PASS Summit, SQLBits, S...

vikram on 3/4/2009

Definitely a good intro to optimization. Thanks.

darkainsoul on 3/19/2009

Very useful video thanks

Scott McDonald on 3/19/2009

One of the better videos. Well done.

ElSuket on 3/19/2009

Hello, There is no need to create statistics after having created the index ;)

Jack Kress on 3/19/2009

Thanks!

Lonnie Sale on 3/20/2009

Could not hear presentation. My volume was up, was there a problem on your end?

Mark Sopczak on 3/20/2009

Very good.

Edward Thompson on 3/21/2009

Wonderfully simple and useful. Thank you.

B750460146 on 3/23/2009

Are your servers dead - have tried 3 different proxies now, all attempts run like S... , your site will stop to buffer 2-3 times each second !? Well, i'll have to retry in a while...

Andy Warren on 3/24/2009

B75 - we use a 3rd party content distribution network, so it's not a case of our servers being overloaded, they only serve the pages (not video). It's possible it was a localized problem, but we'll monitor to see if its occuring everywhere.

virender on 4/1/2009

great

khurram bhatti on 5/24/2009

Good Stuff...!

satish on 9/29/2009

excellent

Tom Tait on 10/29/2009

More video would be nice. How about one concerning passing variables from parent to child SSIS packs?

rotaruro on 12/21/2009

excellent

Ranjith on 2/21/2010

Nice one. Thanks

Arun on 3/13/2010

very good info

8A7E4A6C54 on 5/18/2010

Great

Kent on 5/29/2010

Nice video...

Dima on 7/22/2010

Thanks for video !

Anil Babu on 8/3/2010

good

Amit on 5/31/2011

Superb .. I was not aware that DTA is included in SSMS. Thanks to author

Carlos B. Vasquez on 8/15/2011

nice way of combining the execution plan with the DTA to examine and apply these recommendations accordingly.

Rohan on 8/15/2011

great clip.Need to have a advance SQL knowledge to use the tool.

b on 8/15/2011

I would like to see more like this. Not certain of narrator's statement..."overlap".

Rene on 8/15/2011

add another ways to optimize without the tuning advisor.

Rubens on 8/15/2011

Very good info, I'm going to try it now on a poor performing proc!

Russell Tye on 8/15/2011

This was good, but I need more detail.

yashpal on 8/16/2011

It is a good video i am looking forward to get the more in future.

Ludo Bernaerts on 8/16/2011

level to low

Vamsi on 8/21/2011

Good. Is there any video to explain the execution plan

Dan on 8/22/2011

Robotic but thanks...

Olu on 8/25/2011

Thanks! I'll really find this tool very useful.

Maurice Ivory on 1/13/2012

I didn't quite understand this video

Prakash on 7/30/2012

nice