Improve SQL Server performance using profiler and tuning advisor

See our other Step by Step video series below :-

This video first starts with a simple explanation of what is a SQL server profiler and performance tuning wizard. After completing the basic concepts it then demonstrates a simple example using two tables by capturing the work load and understanding the recommendations given by the tuning wizard.

[dnfvideo]

Do not miss our Interview Question video series

[ankurkulshrestha]

Working on sql server as my secondary skill for 4 years now but never gave tuner a chance. Thanks for letting me know how easy and effective it is.

[rahulmathew]

Thank You Sir for teaching this. You are a great IT guru teacher for us. 10 years in the industry and I still come and watch your videos to learn and re-learn

[adegboyegaoshinowo]

Excellent delivery on this topic. Clearly explained and demonstrated in a record time of 13.12 mins. Very helpful for me.

[abcdefg]

Thank you for using clear English and not using any Indian languages. Greetings from Romania.

[maraduarz]

the process explained in this 13 mins helped me save tons of time, great step-by-step, as well as conceptual information.

[-sematube]

The most easy way is: write the query on SSMS new query as you did ... then select the query, right click, and choose Analyze Query in database Engine Tuning Advisor. This makes life more easier.

[suryaarjun]

What a outstanding explanation about sql profiler and tuning advisor.... Simply Awesome!!!

[KDOERAK]

I didn't know about the Tuning Advisor - thank you very much!

[AchieversDataEngineering]

10 years of old video but still very useful. Thanks!

[Me.anything]

Thank you sir. This is years old video and I am watching today😐 anyway better late than never.

[aniket]

Great Video! Clear explanation for the common problem of what indexes should be used. You need some background of what indexes are and its types.

[krismaly]

I enjoyed watching this video and recommend to others

SSMS
SQL Profiler
SQL Tuning Adviser
explained well in a short duration

Thanks for educating the community and appreciate your volunteership

I would appreciate if you could publish some more videos on Profiler and Tuning Advisor 

Thanks a bunch

[meisammofidi]

Perfect! very efficient and straight forward demonstration.

[alexxx]

Very well spoken indian IT guy, and great presentation.

[rameezkhan]

only one word for your explanation
outstanding

[dnfvideo]

Thanks, I personally feel proud for this video.

[ANILMAHADEV]

Great Job! To the point unlike other videos!! Kudos to the Speaker!

[swanky]

The best video for newbees to kw abt SQL Profiler & Tuning Advisor.

[nandakumaras]

Excellent Video. It helped me a lot. Please let me know if any other videos are available to explain more on SQL Profiler usage and their column selection.