Improve SQL Server performance using profiler and tuning advisor

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

ความคิดเห็น •

  • @dnfvideo
    @dnfvideo  3 ปีที่แล้ว +1

    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

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

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

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

  • @abcdefg9613
    @abcdefg9613 5 ปีที่แล้ว +1

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

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

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

  • @ANILMAHADEV
    @ANILMAHADEV 11 ปีที่แล้ว +1

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

  • @KDOERAK
    @KDOERAK 11 ปีที่แล้ว +6

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

  • @AchieversDataEngineering
    @AchieversDataEngineering 2 ปีที่แล้ว +1

    10 years of old video but still very useful. 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....

  • @AIL2702
    @AIL2702 12 ปีที่แล้ว

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

  • @dnfvideo
    @dnfvideo  12 ปีที่แล้ว +3

    Thanks ,I personally feel proud for this video.

    • @vinaygb8610
      @vinaygb8610 4 ปีที่แล้ว +1

      Very nice explanation and helpful information.Thanks

  • @meisammofidi13
    @meisammofidi13 3 ปีที่แล้ว +2

    Perfect! very efficient and straight forward demonstration.

  • @rameezkhan2849
    @rameezkhan2849 4 ปีที่แล้ว

    only one word for your explanation
    outstanding

  • @manav1184
    @manav1184 12 ปีที่แล้ว

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

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

  • @koppalahareesh2192
    @koppalahareesh2192 7 ปีที่แล้ว

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

  • @adugnawolde3260
    @adugnawolde3260 4 ปีที่แล้ว

    ONE OF THE BEST APPROACH. YOU ARE GREAT

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

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

  • @balasurf1281
    @balasurf1281 4 ปีที่แล้ว

    Super and precise example. Hats off to you.

  • @MdAnwarulAzim
    @MdAnwarulAzim 9 ปีที่แล้ว +1

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

  • @hellofriend2012
    @hellofriend2012 8 ปีที่แล้ว

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

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

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

  • @04k91a033
    @04k91a033 12 ปีที่แล้ว

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

  • @manthrisrinivas6763
    @manthrisrinivas6763 ปีที่แล้ว

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

  • @Gowthamreddykunduru
    @Gowthamreddykunduru 11 ปีที่แล้ว

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

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

  • @ranjithkumar8883
    @ranjithkumar8883 10 ปีที่แล้ว

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

  • @Partha701
    @Partha701 12 ปีที่แล้ว

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

  • @ppsteiner
    @ppsteiner 8 ปีที่แล้ว

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

  • @ЛіляЛеськів-ц9э
    @ЛіляЛеськів-ц9э 2 ปีที่แล้ว

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

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 ปีที่แล้ว

    Nice explanation on SQL profiler and database Tuning advisor thank you sir, for this 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

  • @manojnarasimhan
    @manojnarasimhan 13 ปีที่แล้ว

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

  • @sknoor261
    @sknoor261 9 ปีที่แล้ว

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

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

  • @girishuppal
    @girishuppal 8 ปีที่แล้ว +2

    Nice articulation. Keep up the good work !!

  • @JHatLpool
    @JHatLpool 2 ปีที่แล้ว

    Nice, clear demonstration. Thanks.

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

  • @prashantpanchal6256
    @prashantpanchal6256 11 ปีที่แล้ว

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

  • @9700653458
    @9700653458 11 ปีที่แล้ว

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

  • @ObjectiveRealityIsKing
    @ObjectiveRealityIsKing 12 ปีที่แล้ว

    Brilliant video with excellent presentation. Thanks.

  • @srinivasrayala6629
    @srinivasrayala6629 10 ปีที่แล้ว

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

  • @sandip_thite
    @sandip_thite 9 ปีที่แล้ว +5

    Outstanding explanation, Thanks sir

  • @demohub
    @demohub 12 ปีที่แล้ว

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

  • @raghavkotla
    @raghavkotla 12 ปีที่แล้ว

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

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

  • @kamleshnakade2277
    @kamleshnakade2277 9 ปีที่แล้ว

    Very Nice demonstration of SQL Server Profiler. Thanks :)

  • @tnaseer1
    @tnaseer1 7 ปีที่แล้ว

    Excellent and simple explanation. Thank you very much.

  • @shivaselvan8858
    @shivaselvan8858 5 หลายเดือนก่อน

    Excellent work! Keep rocking!

  • @mailmesai
    @mailmesai 12 ปีที่แล้ว

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

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

  • @amitgulhane8519
    @amitgulhane8519 7 ปีที่แล้ว

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

  • @maven558
    @maven558 3 ปีที่แล้ว

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

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

  • @kotieswars
    @kotieswars 12 ปีที่แล้ว

    Very NIce Explanation.... Excellent...

  • @runi007
    @runi007 11 ปีที่แล้ว

    Very nice video. Keep this type of videos coming.

  • @rameshm7393
    @rameshm7393 2 ปีที่แล้ว

    Very good explanation. Thanks a lot

  • @tiffinmeister
    @tiffinmeister 6 ปีที่แล้ว

    Clear and concise, very good.

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

  • @riteshranjan2006
    @riteshranjan2006 11 ปีที่แล้ว

    Short & Crisp. Very nice and effective!

  • @maryam_XD123
    @maryam_XD123 5 ปีที่แล้ว +1

    Great explanation.

  • @teshalezewde3270
    @teshalezewde3270 11 ปีที่แล้ว

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

  • @mallunarendra5930
    @mallunarendra5930 9 ปีที่แล้ว

    Outstanding explanation ,simply superb

  • @ladhkay
    @ladhkay 6 ปีที่แล้ว +2

    Awesome video, great job explaining it easily!

  • @drewrash7315
    @drewrash7315 7 ปีที่แล้ว

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

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

  • @YasirShaik
    @YasirShaik 12 ปีที่แล้ว

    Excellent job !! really a nice explanation

  • @eliasalam8101
    @eliasalam8101 11 ปีที่แล้ว

    fantastic and very informative video on tuning.

  • @NabranAboubacar
    @NabranAboubacar 9 หลายเดือนก่อน

    Simple explanation. Thx sir

  • @g.suresh430
    @g.suresh430 4 ปีที่แล้ว

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

  • @jasper5016
    @jasper5016 5 ปีที่แล้ว

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

  • @vigneshvijay2073
    @vigneshvijay2073 5 ปีที่แล้ว +1

    Kudos...Thank you for the wonderful tutorial .

  • @sanjayerram3008
    @sanjayerram3008 10 ปีที่แล้ว +1

    very nice video on profiler ,
    just i need where we can download customer database and all tables which are seen in the video

    • @gpgladys
      @gpgladys 6 ปีที่แล้ว

      Go for Adventure Works DW 2014

  • @devarakondasankararao3802
    @devarakondasankararao3802 5 ปีที่แล้ว

    Thanks for this SQL profiler and DTA video

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

  • @enigma_mysterium
    @enigma_mysterium 7 ปีที่แล้ว

    Concise and clean tutorial. thanks a lot.

  • @lovilovec
    @lovilovec 11 ปีที่แล้ว

    nice work.....keep posting such a nice things...you are good at it..

  • @kalaiarasan364
    @kalaiarasan364 3 ปีที่แล้ว

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

  • @silpaganesh
    @silpaganesh 12 ปีที่แล้ว

    good work . very nice explanation. Thank you.

  • @snehalkolhe2416
    @snehalkolhe2416 3 ปีที่แล้ว

    Your videos are so helpful

  • @ashisswarn2781
    @ashisswarn2781 10 หลายเดือนก่อน

    Very well explained!!!

  • @wanderertechie
    @wanderertechie 12 ปีที่แล้ว

    Very nicely executed.

  • @santoshbaggam9315
    @santoshbaggam9315 9 ปีที่แล้ว

    thank you.. it is so useful for freshers

  • @tushibhaque863
    @tushibhaque863 8 ปีที่แล้ว

    very well explained..thanks for ur effort..

  • @cheran15
    @cheran15 12 ปีที่แล้ว

    Thanks ...Very Clear Explanation

  • @mannychohan
    @mannychohan 10 ปีที่แล้ว +9

    Great job. Thanks for posting this video.

  • @abidhussain2967
    @abidhussain2967 9 ปีที่แล้ว

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

  • @uddhav23
    @uddhav23 7 ปีที่แล้ว

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

  • @deltatrends7962
    @deltatrends7962 4 ปีที่แล้ว

    Brief, well explained. Thank you.

  • @Aminchavarria
    @Aminchavarria 4 ปีที่แล้ว +1

    Great!

  • @stuggyg01
    @stuggyg01 12 ปีที่แล้ว

    Very good video, good example.

  • @jfaquinojr
    @jfaquinojr 4 ปีที่แล้ว

    Today i learned a couple of things. Thank you