Log_reuse_wait_desc as Availability_Replica - How to fix

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

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

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

    Simply Superb Chandu. Excellent 👌👌👌👌👌👌👌👌👌👌👌

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

    Bro your explaining like spoon feeding that was appreciable

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

    Good job @Chandu👏👏👏

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

    i am trying to job as SQL dba sir your explanationis very nice and easy i am expecting more from your as early as possible thank you sir

  • @srinivas-dh3rx
    @srinivas-dh3rx ปีที่แล้ว +2

    Appriciate your efforts and time spent for explaining the regular issues facing by mssql DBA's

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

    Excellent sir.. Please do more videos on troubleshooting. You have explained very well.. Good job.

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

    its a great help slow learners, as the teaching method is like peeling banana and eating...
    Awesome patience with expert knowledge..

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

    Your explanation is easy to understand. Do more videos brother on regular issues.

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

    Well Explained. love your video boss!!!

  • @Shaolin80000
    @Shaolin80000 2 หลายเดือนก่อน +1

    Great video. Thanks

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

    Good explanation brother. Keep doing well👍

  • @sriharibandi2907
    @sriharibandi2907 7 หลายเดือนก่อน +1

    Super explanation and really helpful

  • @Greatest.Everrr
    @Greatest.Everrr 9 หลายเดือนก่อน +1

    Very good explanation 👏

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

    Very nice explain u have done sir ji

  • @AjayKumar-c2h2q
    @AjayKumar-c2h2q 9 หลายเดือนก่อน

    sir please keep posting videos...don't stop.. it's very helpful in learning... or please share a channel where we can join online classes

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

      Sure, thanks for the feedback. Not getting time, will start uploading. I will let you know if I start a new batch for alwayson. Currently performance tuning batch has started.

    • @thanuhari688
      @thanuhari688 7 หลายเดือนก่อน

      Azure sql have u stared any batch sir ??kindly let me know sir

    • @chandustechnet4214
      @chandustechnet4214  7 หลายเดือนก่อน

      Sure, thanks

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

    Your explanation is so simple to understand anyone
    How to contact you for some critical topic
    Like Performance issue and Dag concept
    Thanks again

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

      Thanks for the feedback. Feel free to drop me an email at sqlwithchandu@gmail.com.

  • @itechnicalstudy
    @itechnicalstudy 11 หลายเดือนก่อน

    Very nice explanation

  • @ssk3532
    @ssk3532 10 หลายเดือนก่อน +1

    Great👏

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

    nice explanation bro..but better to use graphical user interface instead of cmd prompt to configure min and max server options..it easy to understand for everyone...just my opinion only.

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

      Thanks for the suggestion bro. This video is to start the service using minimal configuration mode(/f), single user mode(/m) when the services are not startup due to memory pressure. You might not be able to connect SSMS and change the memory configuration in such situation.

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

      Yes u r right, I got u r point... Keep posting such kind of vedious brother.

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

    Thank you

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

    Chandu,
    Can you please post a detailed video on Accelerated Database Recovery (ADR) feature in detail. Pros and cons as well.
    Thanks

  • @thanuhari688
    @thanuhari688 7 หลายเดือนก่อน

    Nice explained sir but last few seconds some confusion sir ..whether we need to take log backup from primary to secondary to restore sir ??

    • @chandustechnet4214
      @chandustechnet4214  7 หลายเดือนก่อน

      Yes, but depends on the issue. If you wanted to remove database from secondary and wanted to reseed. Please try with log backups first than restoring the entire database.

  • @kuswas_rr
    @kuswas_rr 11 หลายเดือนก่อน +1

    🙏

  • @labibchy9293
    @labibchy9293 8 หลายเดือนก่อน

    how to connect with you ?

    • @chandustechnet4214
      @chandustechnet4214  8 หลายเดือนก่อน

      You can contact me on, sqlwithchandu@gmail.com

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

    👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌

  • @shivajisriram5782
    @shivajisriram5782 11 หลายเดือนก่อน

    log_reuse_wait_desc as replication where the database is participating in always on not in replication - how to fix

    • @chandustechnet4214
      @chandustechnet4214  11 หลายเดือนก่อน

      Did you check if CT or CDC enabled? You would not see replication if it's just Alwayson configured.

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

    Hi sir...
    I am facing the log send rate too low.... So the log size also increases and log send queue is increasing...... What the solution here

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

      Check the flow control from performance counters. It happens because of the flow control. You can restart the endpoint on secondary which will reset the flow control threshold and will increase the send rate

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

      @@chandustechnet4214 Thank you for your wonderful information.....

  • @Ameeralitp
    @Ameeralitp 10 หลายเดือนก่อน +1

    you are repeating too many times. which i hate it in your video

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

      Thanks for the feedback. Will try not to repeat. I just wanted to make sure that everyone understands clearly.