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: WSFC

Using Distributed Network Names with Availability Groups

August 23, 2020 Sean Gallardy 1 Comment

I’ve been asked this question a few times, so I feel it’s worth writing about, which is, “Are Distributed Network…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, DNN, FCI, NotQuiteYet, WSFC

Attempting to recycle all monitors that have loaded the DLL sqsrvres.dll or hadrres.dll and you notice a SQL FCI/AG failed health checks

August 20, 2020 Sean Gallardy

I won’t say I told you so… I will, however, point out common AG question #8… I’m not sure why…

Continue Reading →

Posted in: HA/DR, Maintenance, NotASQLServerProblem, SQL Server Filed under: HADR, Patching, SQL Server, WSFC

Stop using Sys.dm_hadr_cluster_members for “quorum” information

May 9, 2020 Sean Gallardy 1 Comment

Update 5/24/2022: I’ve updated the DMV to reflect the various node and witness dynamic settings with a new column at…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: DMV, DoesntWorkLikeYoudThink, HADR, Monitoring, SQL Server, WSFC

Subscribe via RSS!

Recent Comments

  • Contained Availability Groups in SQL Server 2022 – Curated SQL on SQL Server 2022 – Contained AGs – Overview
  • Sean Gallardy on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Hannah Vernon on Trace Flag 2861 – The Trace Flag, The Myth, The Legend

Archives

  • 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