Improve SQL Server performance using profiler and tuning advisor
Vložit
- čas přidán 22. 02. 2011
- For more such videos visit www.questpond.com
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
Learn Data Science in 1 hour :- tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- tinyurl.com/y6thhkxw
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Learn Tableau step by step :- tinyurl.com/kh6ojyo
Learn SQL Server Step by Step tinyurl.com/ja4zmwu
Learn Angular tutorial step by step tinyurl.com/ycd9j895
Learn MVC Core step by step :- tinyurl.com/y9jt3wkv
Learn C# Step by Step goo.gl/FNlqn3
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn SharePoint Step by Step in 8 hours:- goo.gl/XQKHeP
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.
For more such videos visit www.questpond.com
We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on questpond@questpond.com with the shared link and we will email you the PDF. - Zábava
Do not miss our Interview Question video series
30 Important C# Interview Questions : czcams.com/video/BKynEBPqiIM/video.html
25 Important ASP.NET Interview Questions : czcams.com/video/pXmMdmJUC0g/video.html
25 Angular Interview Questions : czcams.com/video/-jeoyDJDsSM/video.html
5 MSBI Interview Questions : czcams.com/video/5E815aXAwYQ/video.html
the process explained in this 13 mins helped me save tons of time, great step-by-step, as well as conceptual information.
Excellent delivery on this topic. Clearly explained and demonstrated in a record time of 13.12 mins. Very helpful for me.
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
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.
What a outstanding explanation about sql profiler and tuning advisor.... Simply Awesome!!!
The best overview I've seen thus far. Thank you so much!
Thank you for using clear English and not using any Indian languages. Greetings from Romania.
Wow! This is the kind of explanation i was looking for. Well done!!!! Look forward to expand my knowledge with your great teaching methods. Thanks!!!!!
Sir,
I am one of your big fan. I like your presentation than any other teacher. Thanks for uploading this
10 years of old video but still very useful. Thanks!
Very Nice Explanation on SQL Profiler and Database Tuning Advisor.Really helped a lot. Good Job
I didn't know about the Tuning Advisor - thank you very much!
Great explanation! Really helped a lot. Unlucky that I can't use Tuning Advisor on Express but will use it on the full version soon!
Great job. Thanks for posting this video.
Perfect! very efficient and straight forward demonstration.
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.
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
Awesome video, great job explaining it easily!
This video is very useful for understading basic knowledge of sql profiler and tuning advisor.
Thank you sir,
Great Job! To the point unlike other videos!! Kudos to the Speaker!
Superb video.This 13 min give me more in SQL Server performance.Thank you so much.
What are indexes?
Nice articulation. Keep up the good work !!
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.
Very helpful, thank you for a great demonstration.
Very Good videos, Which tells what type of index need to be used .
I Like it . Thank you .
Outstanding explanation, Thanks sir
Good video for understading basic knowlage of Server Profiler and Tuning Adviser
Nice explanation on SQL profiler and database Tuning advisor thank you sir, for this video
ONE OF THE BEST APPROACH. YOU ARE GREAT
Very Nice demonstration of SQL Server Profiler. Thanks :)
Simply Awesome Explanation🤩...Hats off to your stratrgy of explaining....
Excellent and simple explanation. Thank you very much.
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.
thank you very much sir !it is 100% helpful video i have an idea what is SQL profiler is now thanks once again great job
Nice, clear demonstration. Thanks.
Excellent, Its very useful for Performance tuning of SQL server.
Thanks for such useful lecture, it's very helpful and easy to understanding!
Kudos...Thank you for the wonderful tutorial .
way of explanation is very nice! Much appreciated
Clear and concise, very good.
your voice is excellent brother.. thank you for this video.. please do more videos on performance tuning tips ..
Short & Crisp. Very nice and effective!
The best video for newbees to kw abt SQL Profiler & Tuning Advisor.
Super and precise example. Hats off to you.
Concise and clean tutorial. thanks a lot.
Very well spoken indian IT guy, and great presentation.
Thank you! Helped me a lot!
Thanks for the clear message. I can't wait for your next video
that video helped me a lot! thank you for very pointy and useful instructions. it is always possible to learn lots of theory behind it after you have been given such a practical approach! :)
Excellent work! Keep rocking!
Outstanding explanation ,simply superb
only one word for your explanation
outstanding
Thanks for this SQL profiler and DTA video
Thank You very much! Great video, very informative
Very detailed and nice video, Thanks alot!
Great explaination! To find where to add indexes in query.
Video is awesome.. & the best thing is you have explained it as per the prospective of people who are new to database. I am form the testing background, just wanna know whats the Profiler and tuning adviser & am clear with each and every word. Thanks a lot.
Excellent Video tutorials.....speaker is very nice.
This is very helpful. Thanks a lot for sharing this video.
Thanks for the useful tips!
Thank you very much. I learned so much from your videos.
Very nice... superb .... thanks a lot .... May God bless you for helping lots of people.
Thanks ,I personally feel proud for this video.
Very nice explanation and helpful information.Thanks
Great video !! Thanks
Brief, well explained. Thank you.
One of the great videos that I have ever seen which is really helpful for optimizing the database performance but one small question is raising in my mind why it has shown the reason as the invalid object in the tuning log even the table exists in the database.
Today i learned a couple of things. Thank you
Awesome video ! Awesome teacher !
Thank you man, have a great Day ..
very well explained, thank you!
excellent explanation sir, please provide some isolation levels and transaction level explanation, which would be more useful for me
Simple and understandable
thanks you for sharing such video with us
Nice work :)
Fantastic video!
Thanks ...Very Clear Explanation
Thanks... This is very helpful and your presentation is too good.
Clear all way , Great Job
Excellent explanation...so clear to the dot .
Thanks
Awesome Thanks!!!
Very good explanation. Thanks a lot
Very well explained!!!
Brilliant video with excellent presentation. Thanks.
Thank you sir. This is years old video and I am watching today😐 anyway better late than never.
Iam watching this video, still this is mighty helpful:-)
Very and neat and clear explanation. Good work and keep it up.
Excellent explanation, thanks for this video
very nice video. thanks a lot!!
Amazing explanation.. Hope to get more from u!!!
Your videos are so helpful
Very detailed explanation and very effective , Thanks for posting the video
Great video. Keep the good work going
thank you a lot , perfect video to start with..
Fantastic Teaching...
Thank You So much..!!!
Very nice & high class video on SQL profiler....thanks a lot
Superb video, Thank you!!
Very nice video, thank you.
This video is really awesome !!
Excellent Video!! thank you so much :D
I enjoyed ur video.. superd video on profile and turning.. i got a perfect trainer now, so i am going to subscribe now..
Great Video! Thanks!
Very NIce Explanation.... Excellent...