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

  • Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers
  • Error 35217 And Availability Groups /SMH
  • Stop using Sys.dm_hadr_cluster_members for “quorum” information

Recent Comments

  • Sean Gallardy on Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers
  • Ed Vassie on Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers
  • Sean Gallardy on Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers

Archives

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