Improve SQL Server performance using profiler and tuning advisor

Поделиться
HTML-код
  • Опубликовано: 3 дек 2024

Комментарии • 250

  • @dnfvideo
    @dnfvideo  3 года назад +1

    Do not miss our Interview Question video series
    30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
    25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
    25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
    5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html

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

  • @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 лет назад +3

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

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

  • @suryaarjun2299
    @suryaarjun2299 6 лет назад +1

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

  • @abcdefg9613
    @abcdefg9613 5 лет назад +1

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

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

  • @AchieversDataEngineering
    @AchieversDataEngineering 2 года назад +1

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

  • @meisammofidi13
    @meisammofidi13 3 года назад +2

    Perfect! very efficient and straight forward demonstration.

  • @ANILMAHADEV
    @ANILMAHADEV 11 лет назад +1

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

  • @swanky234
    @swanky234 11 лет назад

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

  • @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 4 года назад +1

      Very nice explanation and helpful information.Thanks

  • @hrushikeshkhonde7079
    @hrushikeshkhonde7079 Год назад

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

  • @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?

  • @koppalahareesh2192
    @koppalahareesh2192 7 лет назад

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

  • @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:-)

  • @hellofriend2012
    @hellofriend2012 8 лет назад

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

  • @rameezkhan2849
    @rameezkhan2849 4 года назад

    only one word for your explanation
    outstanding

  • @sandip_thite
    @sandip_thite 9 лет назад +5

    Outstanding explanation, Thanks sir

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

  • @MdAnwarulAzim
    @MdAnwarulAzim 9 лет назад +1

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

  • @alexxx4434
    @alexxx4434 4 года назад

    Very well spoken indian IT guy, and great presentation.

  • @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

  • @manav1184
    @manav1184 12 лет назад

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

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

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

  • @sknoor261
    @sknoor261 9 лет назад

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

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 лет назад

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

  • @adugnawolde3260
    @adugnawolde3260 4 года назад

    ONE OF THE BEST APPROACH. YOU ARE GREAT

  • @girishuppal
    @girishuppal 8 лет назад +2

    Nice articulation. Keep up the good work !!

  • @prashantpanchal6256
    @prashantpanchal6256 11 лет назад

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

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

  • @manthrisrinivas6763
    @manthrisrinivas6763 Год назад

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

  • @ranjithkumar8883
    @ranjithkumar8883 10 лет назад

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

  • @ЛіляЛеськів-ц9э
    @ЛіляЛеськів-ц9э 2 года назад

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

  • @JHatLpool
    @JHatLpool 2 года назад

    Nice, clear demonstration. Thanks.

  • @srinivasrayala6629
    @srinivasrayala6629 10 лет назад

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

  • @tnaseer1
    @tnaseer1 7 лет назад

    Excellent and simple explanation. Thank you very much.

  • @Gowthamreddykunduru
    @Gowthamreddykunduru 11 лет назад

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

  • @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

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

  • @mallunarendra5930
    @mallunarendra5930 9 лет назад

    Outstanding explanation ,simply superb

  • @04k91a033
    @04k91a033 12 лет назад

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

  • @mannychohan
    @mannychohan 10 лет назад +9

    Great job. Thanks for posting this video.

  • @chamelion1red
    @chamelion1red 11 лет назад

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

  • @swethajella
    @swethajella 13 лет назад

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

  • @Partha701
    @Partha701 12 лет назад

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

  • @kamleshnakade2277
    @kamleshnakade2277 9 лет назад

    Very Nice demonstration of SQL Server Profiler. Thanks :)

  • @maryam_XD123
    @maryam_XD123 5 лет назад +1

    Great explanation.

  • @manojnarasimhan
    @manojnarasimhan 13 лет назад

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

  • @vigneshvijay2073
    @vigneshvijay2073 5 лет назад +1

    Kudos...Thank you for the wonderful tutorial .

  • @ladhkay
    @ladhkay 6 лет назад +2

    Awesome video, great job explaining it easily!

  • @demohub
    @demohub 12 лет назад

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

  • @ObjectiveRealityIsKing
    @ObjectiveRealityIsKing 12 лет назад

    Brilliant video with excellent presentation. Thanks.

  • @9700653458
    @9700653458 11 лет назад

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

  • @riteshranjan2006
    @riteshranjan2006 11 лет назад

    Short & Crisp. Very nice and effective!

  • @BonnieBUsher
    @BonnieBUsher 10 лет назад +1

    Very helpful, thank you for a great demonstration.

  • @amitgulhane8519
    @amitgulhane8519 7 лет назад

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

  • @tiffinmeister
    @tiffinmeister 6 лет назад

    Clear and concise, very good.

  • @rameshm7393
    @rameshm7393 2 года назад

    Very good explanation. Thanks a lot

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

  • @maven558
    @maven558 3 года назад

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

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

  • @raghavkotla
    @raghavkotla 12 лет назад

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

  • @g.suresh430
    @g.suresh430 4 года назад

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

  • @enigma_mysterium
    @enigma_mysterium 7 лет назад

    Concise and clean tutorial. thanks a lot.

  • @recsunil
    @recsunil 10 лет назад

    Excellent explanation, thanks for this video

  • @shivaselvan8858
    @shivaselvan8858 5 месяцев назад

    Excellent work! Keep rocking!

  • @kalaiarasan364
    @kalaiarasan364 3 года назад

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

  • @NabranAboubacar
    @NabranAboubacar 9 месяцев назад

    Simple explanation. Thx sir

  • @abidhussain2967
    @abidhussain2967 9 лет назад

    this vedio help me a lot.thanks for providing this vedio

  • @kotieswars
    @kotieswars 12 лет назад

    Very NIce Explanation.... Excellent...

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 лет назад

    Thanks for this SQL profiler and DTA video

  • @tushibhaque863
    @tushibhaque863 8 лет назад

    very well explained..thanks for ur effort..

  • @drewrash7315
    @drewrash7315 7 лет назад

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

  • @2020megastar
    @2020megastar 12 лет назад

    Great explanation for begginers

  • @mailmesai
    @mailmesai 12 лет назад

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

  • @wanderertechie
    @wanderertechie 12 лет назад

    Very nicely executed.

  • @eliasalam8101
    @eliasalam8101 11 лет назад

    fantastic and very informative video on tuning.

  • @uddhav23
    @uddhav23 7 лет назад

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

  • @deltatrends7962
    @deltatrends7962 4 года назад

    Brief, well explained. Thank you.

  • @teshalezewde3270
    @teshalezewde3270 11 лет назад

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

  • @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

  • @santoshbaggam9315
    @santoshbaggam9315 9 лет назад

    thank you.. it is so useful for freshers

  • @jasper5016
    @jasper5016 5 лет назад

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

  • @anithaani3163
    @anithaani3163 9 лет назад +1

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

  • @nayanmakwana7388
    @nayanmakwana7388 6 лет назад

    Clear all way , Great Job

  • @jfaquinojr
    @jfaquinojr 4 года назад

    Today i learned a couple of things. Thank you

  • @runi007
    @runi007 11 лет назад

    Very nice video. Keep this type of videos coming.

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

  • @RealGoatPrxd
    @RealGoatPrxd 12 лет назад

    Very good presentation.

  • @ashisswarn2781
    @ashisswarn2781 10 месяцев назад

    Very well explained!!!

  • @Keyraat
    @Keyraat 12 лет назад

    amazing demonstration.....keep it up

  • @YasirShaik
    @YasirShaik 12 лет назад

    Excellent job !! really a nice explanation

  • @Suraaps1415
    @Suraaps1415 5 лет назад

    Great explanation