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
  • SQL Error Code Search

Tag: Always On

SQL Server 2022, Distributed Availability Groups, and FileStream

August 27, 2023 Sean Gallardy 2 Comments

I don’t often find many people using FileStream in their databases (which isn’t a bad or good thing, in my…

Continue Reading →

Posted in: HA/DR, SQL Server, Trace Flags Filed under: Always On, Availability Groups, Distributed Availability Groups, HADR, SQL Server, trace flag

Non-WSFC Dumping Woes – Assert in ucsconnectionsend.cpp

March 29, 2023 Sean Gallardy 5 Comments

Setup If you’re using availability groups with read-scale or linux (cluster type = None/External), you might want to watch the…

Continue Reading →

Posted in: Dumps, HA/DR, SQL Server Filed under: Always On, Availability Groups, Dump, Dumps, HADR, linux, read-scale, SQL Server, WSFC

Cluster Resource DLL Connectivity In Availability Groups

March 11, 2023 Sean Gallardy

I was recently asked a question, while fixing a cluster connectivity issue, about how the cluster resource dll knows on…

Continue Reading →

Posted in: HA/DR, Security, SQL Server Filed under: Always On, Availability Groups, HADR, NotReallyASQLProblem, ODBC, Security, SNAC, SQL Native Client, SQL Server, WSFC

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

  • JohnKNess on SQL Server 2022, Distributed Availability Groups, and FileStream
  • Hannah Vernon on SQL Server 2022, Distributed Availability Groups, and FileStream
  • happydba on PSA: Uptick in CrowdStrike Issues with SQL Server (Non-Yielding Scheduler)

Archives

  • August 2023
  • July 2023
  • May 2023
  • April 2023
  • March 2023
  • 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