Questions tagged [availability-group]
35 questions
0
votes
1 answer
SQL Server AlwaysOn Availability Groups/Mirroring RPO and Availability
Is there any document clearly telling MAX RPO and Availability attained through SQL Server AlwaysOn Availability Groups/ Mirroring? i.e. 1 min and 99.99% like that?
Jaish Mathews
- 766
- 1
- 9
- 25
0
votes
0 answers
Restrict sys.databases view to connectable databases
How to restrict the results from sys.databases to available databases?
We are changing to availability groups and replica server running on sql-server 2017.
Before this I had a select statement running on master-database to see which datebases are…
Stephan Kallnik
- 1
- 1
- 1
0
votes
2 answers
SOS_SCHEDULER_YIELD spike on Availability Group
I am about to lose my mind on this one.
We have a 3 server availability group from which our applications read from all 3 servers. Runs great 99.9% of the time. Every now and then we get a spike in SOS_SCHEDULER_YIELD. When this happens a lot of…
SteveB
- 769
- 4
- 18
-1
votes
0 answers
SQL Server Sync Connection Usage
We're seeing very high waits for HADR_SYNC_COMMIT at times and after some diagnostic work with iperf3 and the like we think there might a network bandwidth problem.
However we're not central sql staff we mostly do database tuning work so I just…
Simon Bradley
- 39
- 6
-1
votes
1 answer
SQL Server :: Replication Distribution Agent never ending
I'm running SQL Server 2019 Always ON Availability Group with an asynchronous replication.
I use a free tool called IDERA SQL Check and I have spotted the SPID 69 which program name is Replication Distribution Agent. It's always there, staring at me…
Francesco Mantovani
- 10,216
- 13
- 73
- 113