Opinionated SQL
Search

Month: May 2020

HA/DR

Error 35217 And Availability Groups /SMH

Well That Escalated Quickly… Error 35217 translates to, “The thread pool for AlwaysOn Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade AlwaysOn Availability Groups performance. Use the “max worker threads” configuration option to increase number of allowable threads.” which is fairly fatal […]

Read article: Error 35217 And Availability Groups /SMH
DMVs

Stop using Sys.dm_hadr_cluster_members for “quorum” information

Update 5/24/2022: I’ve updated the DMV to reflect the various node and witness dynamic settings with a new column at the end of the DMV called number_of_current_votes. This is only in 2022 and will not be backported. Background I’ve now run across a few different instances where the monitoring for quorum was done via this […]

Read article: Stop using Sys.dm_hadr_cluster_members for “quorum” information