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

  • Error 35217 And Availability Groups /SMH
  • Stop using Sys.dm_hadr_cluster_members for “quorum” information
  • SQL Server Self-Signed Certificate “Vulnerabilities”– FFS Get Off My Lawn

Recent Comments

  • Konstantin Taranov on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Sean Gallardy on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Aaron Bertrand on Trace Flag 2861 – The Trace Flag, The Myth, The Legend

Archives

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