New answers tagged

5 votes

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 ...
Sean Gallardy's user avatar
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 ...
MBuschi's user avatar
  • 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 ...
Laurenz Albe's user avatar

Top 50 recent answers are included