Log_reuse_wait_desc as Availability_Replica - How to fix

This video helps you to troubleshoot and fix the
Log_reuse_wait_desc as Availability_Replica. While troubleshooting we've covered couple of other scenarios as well.
1. How to troubleshoot SQL startup issue
2. How to read and fix memory configuration issue

[@srinivas-dh3rx]

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

[@naidudba9352]

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

[@cheddodu6281]

Bro your explaining like spoon feeding that was appreciable

[@chandustechnet4214]

Glad you liked it

[@chandrakalavathigajjala7525]

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

[@chandustechnet4214]

Sure, thanks for the feedback.

[@kishoreevani5813]

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

[@chandustechnet4214]

Sure, thanks for the feedback.

[@anku8191]

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

[@chandustechnet4214]

Sure, brother. Thanks for the feedback.

[@sriharibandi2907]

Super explanation and really helpful

[@chandustechnet4214]

Glad it was helpful!

[@waseem4231]

Well Explained. love your video boss!!!

[@seyifunmiseyifunmi4412]

Good job @Chandu👏👏👏

[@Greatest.Everrr]

Very good explanation 👏

[@devrai5265]

Very nice explain u have done sir ji

[@senthilkumarg6515]

Good explanation brother. Keep doing well👍

[@chandustechnet4214]

Thank you

[@techmeshow392]

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]

Thanks for the feedback. Feel free to drop me an email at [e-mail].

[@itechnicalstudy]

Very nice explanation

[@chandustechnet4214]

Thank you

[@azuredevops1650]

Thank you

[@asutech2298]

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]

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]

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

[@user-yq1xg6jc3t]

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]

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]

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

[@chandustechnet4214]

Sure, thanks

[@ssk3532]

Great👏

[@kuswas_rr]

🙏

[@naturemusic2343]

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

[@chandustechnet4214]

Sure, thanks for the feedback

[@thanuhari688]

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]

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.

[@annuali7456]

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

[@shivajisriram5782]

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

[@chandustechnet4214]

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

[@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]

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]

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

[@labibchy9293]

how to connect with you ?

[@chandustechnet4214]

You can contact me on, [e-mail]

[@Ameeralitp]

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

[@chandustechnet4214]

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