Viewing 15 posts - 16 through 30 (of 92 total)
Make sure your server properties/database settings/database default locations are set to the drives you expect them to be.
August 21, 2023 at 9:18 pm
Bummer, I figured mine was a fluke. Thanks for the update.
I hear you on the licensing...mine is SPLA so it is very expensive to bump up.
August 21, 2023 at 4:52 pm
I applied CU21 late in July. I had my first restarts this last weekend and both my nodes came up clean with no secondary out of sync issues. Have you...
August 21, 2023 at 4:18 pm
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
This usually points to Kerberos double hop issues. Check you SPN's.
You can use this tool to check it: https://www.microsoft.com/en-US/download/details.aspx?id=39046
August 14, 2023 at 1:30 pm
<sigh> Thanks for the update.
I can confirm I also get some out of sync even though both nodes are on the same patch level.
July 13, 2023 at 11:32 pm
I'm not 100% sure, but check out Erik Darling's sp_HumanEvents.
I believe you can filter by db and username and log to a table.
July 7, 2023 at 2:00 pm
The log backup doesn't align with my AG either.
May 4, 2023 at 2:41 pm
Ooops, I see you already commented on our similar post
May 3, 2023 at 1:56 pm
It does sound similar. I just moved from CU18 to CU19 and am waiting to see if it helped. I am thinking about switching off auto seed before the next...
April 27, 2023 at 9:25 pm
April 21, 2023 at 7:06 pm
Same here, mine were fine for a few years before this issue started about 6 months ago.
April 14, 2023 at 10:17 pm
I also started to experience this about 6 months ago, I wonder if an SP introduced the issue. I had over 300 tiny databases in my AG. I've reduced it...
April 12, 2023 at 3:10 pm
You might try DBCC Updateusage.
I've had to run that coming off some old servers to fix performance issues if it seems storage is your related wait types.
March 24, 2023 at 7:39 pm
Have you reviewed the queries involved in the deadlocks?
Perhaps you are under -indexed or over-indexed. Maybe the queries can be tuned to hit the tables more efficiently (and same order).
March 1, 2023 at 3:04 pm
Viewing 15 posts - 16 through 30 (of 92 total)