New answers tagged high-availability
5
votes
Accepted
HADR_SYNC_COMMIT waits on SQL Server
I wanted to say kudos for diving in and investigating using XE, that's definitely a correct step in the eventual solution. Having said that, it's unlikely we're going to be able to directly help in ...
- 30.1k
3
votes
HADR_SYNC_COMMIT waits on SQL Server
As far as I can see, this is happening because your alwayson AG is synchronously redoing the index reconstruction on the secondary and this takes time. These waits describe exactly this situation.
If ...
- 4,260
0
votes
High Availability postgres db cluster with Patroni and Etcd
No.
Patroni will automatically perform pg_basebackup.
see the answer to 3.
If you have a single etcd, you have a single point of failure. No good. You need to setup an etcd cluster on three nodes ...
- 48k
Top 50 recent answers are included