Viewing 15 posts - 1 through 15 (of 30 total)
Closing the loop here- After almost a year of mostly unproductive back-and-forth on a MS ticket, we finally got the straight answer we suspected (paraphrasing MS response )
February 20, 2024 at 5:30 pm
We just pushed CU22 and are still experiencing the problem. We had 3 dbs that stopped synchronizing even after doubling CPU and RAM per Microsoft recommendations. We are uploading logs...
October 12, 2023 at 8:46 pm
We upgraded to CU21 in mid-July and we are still having the issue. Fingers crossed for CU22 which we will apply in early/mid September.
MS is recommending we double our CPU...
August 21, 2023 at 4:50 pm
Interesting article, thank you. The error returned 1 for the state.
Our dev team updated the code that generates the EF query, and that has resolved the problem (so I won't...
July 19, 2023 at 3:50 pm
Thanks Jeff for the reply. Cardinality Estimation is set the same on both databases and changing it doesn't resolve the issue. All server and database options that you mention (and...
July 14, 2023 at 4:26 pm
Just an update that we are still at a dead-end on this with Microsoft. They claim that it's due to our primary and secondary nodes being on different patch levels,...
July 13, 2023 at 11:04 pm
Thanks Per4inka, I'll share this in our DBA team meeting tomorrow.
BTW we STILL have an open ticket with MS on this so I'll be sure to post back with whatever...
May 24, 2023 at 7:04 pm
We are on CU19 and will go to CU20 in about 3 weeks.
Alex S - thanks for the suggestion. It will be difficult to test as we don't have a...
April 27, 2023 at 10:13 pm
Yes, we are using Automatic seeding for our AGs.
Our reboots most often are due to patching, so we reboot many secondaries at the same time and yes, we always have...
April 21, 2023 at 6:57 pm
Yes we have combed the logs pretty thoroughly and can't find anything definitive. We have a ticket open with MS so I'll post back here with whatever they report.
April 17, 2023 at 12:31 pm
No they are not Sharepoint DBs. 50 DBs/AG is relatively arbitrary, that's just where we landed with our capacity testing when we first implemented AGs about 5 years ago.
Rebooting the...
April 14, 2023 at 10:13 pm
No, 300 dbs on a server. About 50 dbs/AG.
April 14, 2023 at 9:45 pm
Yes, we have ~300 dbs/server and indeed we do see thread exhaustion errors. We are working on an initiative to reduce the number of databases but it's a slow process.
Thanks...
April 10, 2023 at 1:53 pm
Apologies that I am slow in replying, thanks to those who replied. I did query the default trace files, unfortunately they did not go back far enough to capture the...
May 17, 2018 at 9:37 am
Just an update... CHECKDB found 0 allocation errors and 0 consistency errors in database and we are unable to reproduce the error on a copy of the db. I guess we'll...
October 13, 2017 at 12:29 pm
Viewing 15 posts - 1 through 15 (of 30 total)