Improve SQL Server performance using profiler and tuning advisor

Поділитися
Вставка
  • Опубліковано 21 січ 2025

КОМЕНТАРІ • 251

  • @dnfvideo
    @dnfvideo  3 роки тому +1

    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

  • @rahulmathew8713
    @rahulmathew8713 2 роки тому +2

    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

  • @adegboyegaoshinowo9359
    @adegboyegaoshinowo9359 10 років тому +4

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

  • @ankurkulshrestha1308
    @ankurkulshrestha1308 4 роки тому +1

    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.

  • @maraduarz
    @maraduarz 10 років тому +3

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

  • @abcdefg9613
    @abcdefg9613 5 років тому +1

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

  • @suryaarjun2299
    @suryaarjun2299 7 років тому +1

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

  • @AchieversDataEngineering
    @AchieversDataEngineering 3 роки тому +1

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

  • @KDOERAK
    @KDOERAK 11 років тому +6

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

  • @-sematube8347
    @-sematube8347 7 років тому +1

    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.

  • @meisammofidi13
    @meisammofidi13 3 роки тому +2

    Perfect! very efficient and straight forward demonstration.

  • @ANILMAHADEV
    @ANILMAHADEV 12 років тому +1

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

  • @krismaly6300
    @krismaly6300 9 років тому

    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

  • @aniket9595
    @aniket9595 10 років тому +1

    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.

  • @dnfvideo
    @dnfvideo  12 років тому +3

    Thanks ,I personally feel proud for this video.

    • @vinaygb8610
      @vinaygb8610 5 років тому +1

      Very nice explanation and helpful information.Thanks

  • @swanky234
    @swanky234 11 років тому

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

  • @hrushikeshkhonde7079
    @hrushikeshkhonde7079 Рік тому

    Simply Awesome Explanation🤩...Hats off to your stratrgy of explaining....

  • @Me.anything
    @Me.anything 4 роки тому +4

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

    • @dhineshvs6614
      @dhineshvs6614 3 роки тому

      Iam watching this video, still this is mighty helpful:-)

  • @koppalahareesh2192
    @koppalahareesh2192 7 років тому

    This video is very useful for understading basic knowledge of sql profiler and tuning advisor.
    Thank you sir,

  • @hellofriend2012
    @hellofriend2012 9 років тому

    Sir,
    I am one of your big fan. I like your presentation than any other teacher. Thanks for uploading this

  • @alexxx4434
    @alexxx4434 4 роки тому

    Very well spoken indian IT guy, and great presentation.

  • @adugnawolde3260
    @adugnawolde3260 4 роки тому

    ONE OF THE BEST APPROACH. YOU ARE GREAT

  • @johnnygebre9512
    @johnnygebre9512 5 років тому +1

    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!!!!!

  • @rameezkhan2849
    @rameezkhan2849 4 роки тому

    only one word for your explanation
    outstanding

  • @bhanuteja75
    @bhanuteja75 10 років тому +1

    Superb video.This 13 min give me more in SQL Server performance.Thank you so much.

    • @Umer1993
      @Umer1993 6 років тому

      What are indexes?

  • @manthrisrinivas6763
    @manthrisrinivas6763 Рік тому

    your voice is excellent brother.. thank you for this video.. please do more videos on performance tuning tips ..

  • @balasurf1281
    @balasurf1281 4 роки тому

    Super and precise example. Hats off to you.

  • @ppsteiner
    @ppsteiner 8 років тому

    The best overview I've seen thus far. Thank you so much!

  • @preetimehindru
    @preetimehindru 11 років тому

    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.

  • @sknoor261
    @sknoor261 9 років тому

    Very Nice Explanation on SQL Profiler and Database Tuning Advisor.Really helped a lot. Good Job

  • @AIL2702
    @AIL2702 12 років тому

    Very nice... superb .... thanks a lot .... May God bless you for helping lots of people.

  • @nandakumaras
    @nandakumaras 10 років тому +1

    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.

  • @ranjithkumar8883
    @ranjithkumar8883 10 років тому

    Very Good videos, Which tells what type of index need to be used .
    I Like it . Thank you .

  • @MdAnwarulAzim
    @MdAnwarulAzim 9 років тому +1

    Excellent Video tutorials.....speaker is very nice.

  • @ЛіляЛеськів-ц9э
    @ЛіляЛеськів-ц9э 2 роки тому

    Thanks for such useful lecture, it's very helpful and easy to understanding!

  • @manav1184
    @manav1184 12 років тому

    Thank you very much , Today i got the concept of SQL profiler ..It was nice and very easily understandable Vedio...

  • @girishuppal
    @girishuppal 9 років тому +2

    Nice articulation. Keep up the good work !!

  • @dergimorka6126
    @dergimorka6126 4 роки тому

    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

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 років тому

    Nice explanation on SQL profiler and database Tuning advisor thank you sir, for this video

  • @JHatLpool
    @JHatLpool 2 роки тому

    Nice, clear demonstration. Thanks.

  • @sandip_thite
    @sandip_thite 9 років тому +5

    Outstanding explanation, Thanks sir

  • @prashantpanchal6256
    @prashantpanchal6256 11 років тому

    Good video for understading basic knowlage of Server Profiler and Tuning Adviser

  • @sudhanmaharjan2554
    @sudhanmaharjan2554 8 років тому

    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

  • @04k91a033
    @04k91a033 12 років тому

    Very and neat and clear explanation. Good work and keep it up.

  • @srinivasrayala6629
    @srinivasrayala6629 10 років тому

    Excellent, Its very useful for Performance tuning of SQL server.

  • @aramideshobande8135
    @aramideshobande8135 9 років тому +1

    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!

  • @demohub
    @demohub 12 років тому

    This video is really helpful....Please keep posting. thank you.

  • @amitgulhane8519
    @amitgulhane8519 7 років тому

    Great explaination! To find where to add indexes in query.

  • @tnaseer1
    @tnaseer1 7 років тому

    Excellent and simple explanation. Thank you very much.

  • @purenepalikancha
    @purenepalikancha 5 років тому

    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.

  • @kamleshnakade2277
    @kamleshnakade2277 9 років тому

    Very Nice demonstration of SQL Server Profiler. Thanks :)

  • @shivaselvan8858
    @shivaselvan8858 7 місяців тому

    Excellent work! Keep rocking!

  • @Gowthamreddykunduru
    @Gowthamreddykunduru 11 років тому

    Very detailed explanation and very effective , Thanks for posting the video

  • @Partha701
    @Partha701 12 років тому

    Wonderful and excellent video../Please keep on posting relevant videos for us...Hats off.

  • @AndreDeMoscu
    @AndreDeMoscu 11 років тому

    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! :)

  • @ladhkay
    @ladhkay 6 років тому +2

    Awesome video, great job explaining it easily!

  • @mannychohan
    @mannychohan 11 років тому +9

    Great job. Thanks for posting this video.

  • @riteshranjan2006
    @riteshranjan2006 11 років тому

    Short & Crisp. Very nice and effective!

  • @nuthanmurari
    @nuthanmurari 4 роки тому

    Tuning template is not showing for me.. How to get this template or please show that what and all will be available for tuning?

  • @tiffinmeister
    @tiffinmeister 6 років тому

    Clear and concise, very good.

  • @manojnarasimhan
    @manojnarasimhan 13 років тому

    Thanks... This is very helpful and your presentation is too good.

  • @g.suresh430
    @g.suresh430 4 роки тому

    What a great explanation. 👏👏👏👏. Thank you

  • @maven558
    @maven558 3 роки тому

    Simple and understandable
    thanks you for sharing such video with us
    Nice work :)

  • @vigneshvijay2073
    @vigneshvijay2073 6 років тому +1

    Kudos...Thank you for the wonderful tutorial .

  • @swethajella
    @swethajella 13 років тому

    Excellent explanation...so clear to the dot .
    Thanks

  • @nuthanmurari
    @nuthanmurari 4 роки тому

    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.

  • @surendrag7537
    @surendrag7537 8 років тому

    As you shown in the video this is Point 7 performance tuning . where can we find remaining points viodeos.

  • @mailmesai
    @mailmesai 12 років тому

    great explanation... do need some more topics to be covered by U, like mirroring, logshipping and clustering etc.

  • @jasper5016
    @jasper5016 5 років тому

    Thank you very much. I learned so much from your videos.

  • @mallunarendra5930
    @mallunarendra5930 9 років тому

    Outstanding explanation ,simply superb

  • @ObjectiveRealityIsKing
    @ObjectiveRealityIsKing 12 років тому

    Brilliant video with excellent presentation. Thanks.

  • @drewrash7315
    @drewrash7315 7 років тому

    I saw other videos. They were terrible. Your video was good.

  • @BonnieBUsher
    @BonnieBUsher 10 років тому +1

    Very helpful, thank you for a great demonstration.

  • @enigma_mysterium
    @enigma_mysterium 7 років тому

    Concise and clean tutorial. thanks a lot.

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 років тому

    Thanks for this SQL profiler and DTA video

  • @9700653458
    @9700653458 12 років тому

    Explanation is very clear thanks my friend..........

  • @deltatrends7962
    @deltatrends7962 4 роки тому

    Brief, well explained. Thank you.

  • @rameshm7393
    @rameshm7393 2 роки тому

    Very good explanation. Thanks a lot

  • @chamelion1red
    @chamelion1red 11 років тому

    Very nice & high class video on SQL profiler....thanks a lot

  • @jfaquinojr
    @jfaquinojr 5 років тому

    Today i learned a couple of things. Thank you

  • @chinmay504
    @chinmay504 12 років тому

    Very interesting to learn with your teaching. Please share the link where I can access your other videos on SQL servers. Its agreat show.

  • @maryam_XD123
    @maryam_XD123 5 років тому +1

    Great explanation.

  • @INDIAN_8611
    @INDIAN_8611 10 років тому

    I enjoyed ur video.. superd video on profile and turning.. i got a perfect trainer now, so i am going to subscribe now..

  • @teshalezewde3270
    @teshalezewde3270 11 років тому

    Thanks for the clear message. I can't wait for your next video

  • @uddhav23
    @uddhav23 8 років тому

    This is very helpful. Thanks a lot for sharing this video.

  • @NabranAboubacar
    @NabranAboubacar 11 місяців тому

    Simple explanation. Thx sir

  • @raghavkotla
    @raghavkotla 12 років тому

    good job ....... I actually liked the command and confidence on the topic
    cheers

  • @kalaiarasan364
    @kalaiarasan364 3 роки тому

    Very much clearly explained tq sir
    I need for production environment pls help ..

  • @recsunil
    @recsunil 10 років тому

    Excellent explanation, thanks for this video

  • @srinivasavula7268
    @srinivasavula7268 8 років тому

    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....

    • @dnfvideo
      @dnfvideo  8 років тому

      Please mail us your query at questpond@questpond.com

  • @tushibhaque863
    @tushibhaque863 8 років тому

    very well explained..thanks for ur effort..

  • @t33d33
    @t33d33 4 роки тому

    Thank You very much! Great video, very informative

  • @nayanmakwana7388
    @nayanmakwana7388 6 років тому

    Clear all way , Great Job

  • @jessicajesoro
    @jessicajesoro 8 років тому

    What if i have already an index??can i still follow whats on your tutorial?

    • @kimfucku8074
      @kimfucku8074 8 років тому +1

      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.

  • @santoshbaggam9315
    @santoshbaggam9315 9 років тому

    thank you.. it is so useful for freshers

  • @runi007
    @runi007 11 років тому

    Very nice video. Keep this type of videos coming.

  • @Lolo_NwanyiOma
    @Lolo_NwanyiOma 9 років тому

    Very detailed and nice video, Thanks alot!

  • @snehalkolhe2416
    @snehalkolhe2416 3 роки тому

    Your videos are so helpful

  • @SushrutKanetkar
    @SushrutKanetkar 6 років тому

    Awesome video ! Awesome teacher !

  • @anithaani3163
    @anithaani3163 9 років тому +1

    excellent explanation sir, please provide some isolation levels and transaction level explanation, which would be more useful for me