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

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 Leave a comment

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

Background I’ve now run across a few different instances where the monitoring for quorum was done via this DMV. On…

Continue Reading →

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

Recent Posts

  • Refresh DEK for DBID and FileID Errorlog Messages
  • Network Throughput Hysteria
  • VM Backups + SQL HA = SQL AlwaysOff

Recent Comments

  • Sean Gallardy on Network Throughput Hysteria
  • Max Vernon on Network Throughput Hysteria
  • Sean Gallardy on Network Throughput Hysteria

Archives

  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2021 Opinionated SQL