Do not miss our Interview Question video series 30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html 25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html 25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html 5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html
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
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.
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
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!!!!!
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. 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.
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.
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! :)
When i am trying to open Database tuning window from Profiler -> Tools Menu and it throws "Database Engine Tuning Advisor doesnot support SQL Express.(DTA Client). Please help me on this.
hi thanks for the video...u explained about query with two filters and as per the analysis created the non cluster index also..but what about the query with only one filter..again we have create one more index or pre created index will suit for this...pls explain....
You can create many non-clustered indexes on a table. A clustered index can only be defined one per table. Be carefull with indexes, they can also have an adverse effect on the performance if you perform large inserts on a table. Also check out the execution plan to understand how your query is actually executed.
Do not miss our Interview Question video series
30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html
25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html
25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html
5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html
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
Excellent delivery on this topic. Clearly explained and demonstrated in a record time of 13.12 mins. Very helpful for me.
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.
the process explained in this 13 mins helped me save tons of time, great step-by-step, as well as conceptual information.
Thank you for using clear English and not using any Indian languages. Greetings from Romania.
What a outstanding explanation about sql profiler and tuning advisor.... Simply Awesome!!!
10 years of old video but still very useful. Thanks!
I didn't know about the Tuning Advisor - thank you very much!
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.
Perfect! very efficient and straight forward demonstration.
Great Job! To the point unlike other videos!! Kudos to the Speaker!
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
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.
Thanks ,I personally feel proud for this video.
Very nice explanation and helpful information.Thanks
The best video for newbees to kw abt SQL Profiler & Tuning Advisor.
Simply Awesome Explanation🤩...Hats off to your stratrgy of explaining....
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:-)
This video is very useful for understading basic knowledge of sql profiler and tuning advisor.
Thank you sir,
Sir,
I am one of your big fan. I like your presentation than any other teacher. Thanks for uploading this
Very well spoken indian IT guy, and great presentation.
ONE OF THE BEST APPROACH. YOU ARE GREAT
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!!!!!
only one word for your explanation
outstanding
Superb video.This 13 min give me more in SQL Server performance.Thank you so much.
What are indexes?
your voice is excellent brother.. thank you for this video.. please do more videos on performance tuning tips ..
Super and precise example. Hats off to you.
The best overview I've seen thus far. Thank you so much!
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.
Very Nice Explanation on SQL Profiler and Database Tuning Advisor.Really helped a lot. Good Job
Very nice... superb .... thanks a lot .... May God bless you for helping lots of people.
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.
Very Good videos, Which tells what type of index need to be used .
I Like it . Thank you .
Excellent Video tutorials.....speaker is very nice.
Thanks for such useful lecture, it's very helpful and easy to understanding!
Thank you very much , Today i got the concept of SQL profiler ..It was nice and very easily understandable Vedio...
Nice articulation. Keep up the good work !!
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 explanation on SQL profiler and database Tuning advisor thank you sir, for this video
Nice, clear demonstration. Thanks.
Outstanding explanation, Thanks sir
Good video for understading basic knowlage of Server Profiler and Tuning Adviser
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
Very and neat and clear explanation. Good work and keep it up.
Excellent, Its very useful for Performance tuning of SQL server.
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!
This video is really helpful....Please keep posting. thank you.
Great explaination! To find where to add indexes in query.
Excellent and simple explanation. Thank you very much.
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.
Very Nice demonstration of SQL Server Profiler. Thanks :)
Excellent work! Keep rocking!
Very detailed explanation and very effective , Thanks for posting the video
Wonderful and excellent video../Please keep on posting relevant videos for us...Hats off.
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! :)
Awesome video, great job explaining it easily!
Great job. Thanks for posting this video.
Short & Crisp. Very nice and effective!
Tuning template is not showing for me.. How to get this template or please show that what and all will be available for tuning?
Clear and concise, very good.
Thanks... This is very helpful and your presentation is too good.
What a great explanation. 👏👏👏👏. Thank you
Simple and understandable
thanks you for sharing such video with us
Nice work :)
Kudos...Thank you for the wonderful tutorial .
Excellent explanation...so clear to the dot .
Thanks
When i am trying to open Database tuning window from Profiler -> Tools Menu and it throws "Database Engine Tuning Advisor doesnot support SQL Express.(DTA Client). Please help me on this.
As you shown in the video this is Point 7 performance tuning . where can we find remaining points viodeos.
great explanation... do need some more topics to be covered by U, like mirroring, logshipping and clustering etc.
Thank you very much. I learned so much from your videos.
Outstanding explanation ,simply superb
Brilliant video with excellent presentation. Thanks.
I saw other videos. They were terrible. Your video was good.
Very helpful, thank you for a great demonstration.
Concise and clean tutorial. thanks a lot.
Thanks for this SQL profiler and DTA video
Explanation is very clear thanks my friend..........
Brief, well explained. Thank you.
Very good explanation. Thanks a lot
Very nice & high class video on SQL profiler....thanks a lot
Today i learned a couple of things. Thank you
Very interesting to learn with your teaching. Please share the link where I can access your other videos on SQL servers. Its agreat show.
Great explanation.
I enjoyed ur video.. superd video on profile and turning.. i got a perfect trainer now, so i am going to subscribe now..
Thanks for the clear message. I can't wait for your next video
This is very helpful. Thanks a lot for sharing this video.
Simple explanation. Thx sir
good job ....... I actually liked the command and confidence on the topic
cheers
Very much clearly explained tq sir
I need for production environment pls help ..
Excellent explanation, thanks for this video
hi thanks for the video...u explained about query with two filters and as per the analysis created the non cluster index also..but what about the query with only one filter..again we have create one more index or pre created index will suit for this...pls explain....
Please mail us your query at questpond@questpond.com
very well explained..thanks for ur effort..
Thank You very much! Great video, very informative
Clear all way , Great Job
What if i have already an index??can i still follow whats on your tutorial?
You can create many non-clustered indexes on a table. A clustered index can only be defined one per table. Be carefull with indexes, they can also have an adverse effect on the performance if you perform large inserts on a table. Also check out the execution plan to understand how your query is actually executed.
thank you.. it is so useful for freshers
Very nice video. Keep this type of videos coming.
Very detailed and nice video, Thanks alot!
Your videos are so helpful
Awesome video ! Awesome teacher !
excellent explanation sir, please provide some isolation levels and transaction level explanation, which would be more useful for me