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.
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.
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.
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.
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
Simply Superb Chandu. Excellent 👌👌👌👌👌👌👌👌👌👌👌
Bro your explaining like spoon feeding that was appreciable
Glad you liked it
Good job @Chandu👏👏👏
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
Sure, thanks for the feedback.
Appriciate your efforts and time spent for explaining the regular issues facing by mssql DBA's
Excellent sir.. Please do more videos on troubleshooting. You have explained very well.. Good job.
Sure, thanks for the feedback.
its a great help slow learners, as the teaching method is like peeling banana and eating...
Awesome patience with expert knowledge..
Thanks for the feedback
Your explanation is easy to understand. Do more videos brother on regular issues.
Sure, brother. Thanks for the feedback.
Well Explained. love your video boss!!!
Great video. Thanks
Good explanation brother. Keep doing well👍
Thank you
Super explanation and really helpful
Glad it was helpful!
Very good explanation 👏
Very nice explain u have done sir ji
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
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.
Azure sql have u stared any batch sir ??kindly let me know sir
Sure, thanks
Your explanation is so simple to understand anyone
How to contact you for some critical topic
Like Performance issue and Dag concept
Thanks again
Thanks for the feedback. Feel free to drop me an email at sqlwithchandu@gmail.com.
Very nice explanation
Thank you
Great👏
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.
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.
Yes u r right, I got u r point... Keep posting such kind of vedious brother.
Thank you
Chandu,
Can you please post a detailed video on Accelerated Database Recovery (ADR) feature in detail. Pros and cons as well.
Thanks
Sure, thanks for the feedback
Nice explained sir but last few seconds some confusion sir ..whether we need to take log backup from primary to secondary to restore sir ??
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.
🙏
how to connect with you ?
You can contact me on, sqlwithchandu@gmail.com
👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌
log_reuse_wait_desc as replication where the database is participating in always on not in replication - how to fix
Did you check if CT or CDC enabled? You would not see replication if it's just Alwayson configured.
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
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
@@chandustechnet4214 Thank you for your wonderful information.....
you are repeating too many times. which i hate it in your video
Thanks for the feedback. Will try not to repeat. I just wanted to make sure that everyone understands clearly.