Improve SQL Server performance using profiler and tuning advisor
ฝัง
- เผยแพร่เมื่อ 22 ก.พ. 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. - บันเทิง
Do not miss our Interview Question video series
30 Important C# Interview Questions : th-cam.com/video/BKynEBPqiIM/w-d-xo.html
25 Important ASP.NET Interview Questions : th-cam.com/video/pXmMdmJUC0g/w-d-xo.html
25 Angular Interview Questions : th-cam.com/video/-jeoyDJDsSM/w-d-xo.html
5 MSBI Interview Questions : th-cam.com/video/5E815aXAwYQ/w-d-xo.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!!!
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!!!!!
The best overview I've seen thus far. Thank you so much!
Very Nice Explanation on SQL Profiler and Database Tuning Advisor.Really helped a lot. Good Job
Sir,
I am one of your big fan. I like your presentation than any other teacher. Thanks for uploading this
Perfect! very efficient and straight forward demonstration.
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!
10 years of old video but still very useful. Thanks!
Great job. Thanks for posting this video.
Awesome video, great job explaining it easily!
Thank you for using clear English and not using any Indian languages. Greetings from Romania.
Superb video.This 13 min give me more in SQL Server performance.Thank you so much.
What are indexes?
Outstanding explanation, Thanks sir
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.
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.
Great Job! To the point unlike other videos!! Kudos to the Speaker!
Nice articulation. Keep up the good work !!
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
Very helpful, thank you for a great demonstration.
This video is very useful for understading basic knowledge of sql profiler and tuning advisor.
Thank you sir,
Very Good videos, Which tells what type of index need to be used .
I Like it . Thank you .
Excellent and simple explanation. Thank you very much.
ONE OF THE BEST APPROACH. YOU ARE GREAT
Simply Awesome Explanation🤩...Hats off to your stratrgy of explaining....
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! :)
Kudos...Thank you for the wonderful tutorial .
Nice explanation on SQL profiler and database Tuning advisor thank you sir, for this video
Good video for understading basic knowlage of Server Profiler and Tuning Adviser
Nice, clear demonstration. Thanks.
Outstanding explanation ,simply superb
Super and precise example. Hats off to you.
way of explanation is very nice! Much appreciated
Thanks for such useful lecture, it's very helpful and easy to understanding!
Very Nice demonstration of SQL Server Profiler. Thanks :)
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
Excellent, Its very useful for Performance tuning of SQL server.
The best video for newbees to kw abt SQL Profiler & Tuning Advisor.
Concise and clean tutorial. thanks a lot.
only one word for your explanation
outstanding
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.
Thanks for this SQL profiler and DTA video
Clear and concise, very good.
Very nice... superb .... thanks a lot .... May God bless you for helping lots of people.
your voice is excellent brother.. thank you for this video.. please do more videos on performance tuning tips ..
Very well spoken indian IT guy, and great presentation.
Thanks ,I personally feel proud for this video.
Very nice explanation and helpful information.Thanks
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.
Excellent work! Keep rocking!
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.
Great explaination! To find where to add indexes in query.
Short & Crisp. Very nice and effective!
Thank you very much. I learned so much from your videos.
Excellent Video tutorials.....speaker is very nice.
Simple and understandable
thanks you for sharing such video with us
Nice work :)
Brief, well explained. Thank you.
This is very helpful. Thanks a lot for sharing this video.
Excellent explanation, thanks for this video
Thank You very much! Great video, very informative
Thank you very much , Today i got the concept of SQL profiler ..It was nice and very easily understandable Vedio...
Today i learned a couple of things. Thank you
excellent explanation sir, please provide some isolation levels and transaction level explanation, which would be more useful for me
Very detailed and nice video, Thanks alot!
Very detailed explanation and very effective , Thanks for posting the video
Thanks... This is very helpful and your presentation is too good.
Excellent explanation...so clear to the dot .
Thanks
Thanks for the clear message. I can't wait for your next video
Thank you! Helped me a lot!
very well explained, thank you!
Very and neat and clear explanation. Good work and keep it up.
Very good explanation. Thanks a lot
Brilliant video with excellent presentation. Thanks.
Awesome video ! Awesome teacher !
very well explained..thanks for ur effort..
Thank you man, have a great Day ..
What a great explanation. 👏👏👏👏. Thank you
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:-)
I enjoyed ur video.. superd video on profile and turning.. i got a perfect trainer now, so i am going to subscribe now..
super excited with the performance of the Instructor but one issue
where can I download customer database and all tables which are used in the video
Thanks for the useful tips!
good job ....... I actually liked the command and confidence on the topic
cheers
Explanation is very clear thanks my friend..........
Fantastic Teaching...
Thank You So much..!!!
Your videos are so helpful
Great explanation.
Amazing explanation.. Hope to get more from u!!!
thank you.. it is so useful for freshers
Great video. Keep the good work going
Wonderful and excellent video../Please keep on posting relevant videos for us...Hats off.
Simple explanation. Thx sir
thanks for this video. please upload more such videos related to sql dba.
thank you a lot , perfect video to start with..
Clear all way , Great Job
Very well explained!!!
Superb video, Thank you!!