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

Tag: Monitoring

Error 35217 And Availability Groups /SMH

May 9, 2020 Sean Gallardy 1 Comment

Well That Escalated Quickly… Error 35217 translates to, “The thread pool for AlwaysOn Availability Groups was unable to start a…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: HADR, Infrastructure, Monitoring, Performance, SQL Server, Threads, virtualization

Stop using Sys.dm_hadr_cluster_members for “quorum” information

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

  • VM Backups + SQL HA = SQL AlwaysOff
  • Using Distributed Network Names with Availability Groups
  • 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

Recent Comments

  • The Problem with VM Backups of SQL Server – Curated SQL on VM Backups + SQL HA = SQL AlwaysOff
  • Distributed Network Names and Availability Groups – Curated SQL on Using Distributed Network Names with Availability Groups
  • Sean Gallardy on Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers

Archives

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