Skip to content
Opinionated SQL
When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why
  • Send Me Your Thoughts

Tag: Always On

Understanding the HADR_SYNC_COMMIT wait

September 22, 2021 Sean Gallardy 2 Comments

Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…

Continue Reading →

Posted in: HA/DR, SQL Server, Waits Filed under: AGs, Always On, Availability Groups, HADR, HADR_SYNC_COMMIT, Monitoring, SQL Server, Synchronous Commit, Threads, Wait Types, Waits

olved steries #1 – SQL FCI Failovers

April 29, 2021 Sean Gallardy 7 Comments

Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Cheater Cheater, Drivers, FCI, GottaLoveSecurity, HADR, IRPs, NotReallyASQLProblem, olved steries, Security, SQL Server, Windows IO

Undo of Redo – Reverting (and Initializing)

April 12, 2021 Sean Gallardy 1 Comment

Departure Hopefully, you’re not finding this entry because you’re scouring the web for what reverting means while your production server…

Continue Reading →

Posted in: HA/DR, Performance, SQL Server Filed under: Always On, Availability Groups, Recovery, SQL Server

Network Throughput Hysteria

January 29, 2021 Sean Gallardy 6 Comments

I Think My Knee Hurts, I Just Can’t Prove It Hopefully, you really do know if your knee hurts or…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Always On, Gotta Test, networking, SQL Server

Automatic Seeding – Which Replicas Have Permission?

June 9, 2019 Sean Gallardy

There has, for whatever reason, been a recent craze to figure out if a certain replica does or does not…

Continue Reading →

Posted in: HA/DR, Security, SQL Server Filed under: Always On, automatic Seeding, HADR, SQL Server, unsupported

Subscribe via RSS!

Recent Comments

  • Notes on DBATools’s Get-DecryptedObject – Curated SQL on DBATools Decryption Issues Are Not A SQL Server Bug
  • Sean Gallardy on What Are PREEMPTIVE Waits And How Can They Kill Performance
  • Endrju on What Are PREEMPTIVE Waits And How Can They Kill Performance

Archives

  • January 2023
  • November 2022
  • October 2022
  • May 2022
  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2019 Opinionated SQL