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

  • Possible configuration error: 1000000 IO requests allocated
  • olved steries #1 – SQL FCI Failovers
  • Availability Group Long Failover Times

Recent Comments

  • One…Million IO Requests – Curated SQL on Possible configuration error: 1000000 IO requests allocated
  • Sean Gallardy on olved steries #1 – SQL FCI Failovers
  • Tom on olved steries #1 – SQL FCI Failovers

Archives

  • 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 © 2021 Opinionated SQL