I meant to write this almost a year ago, but then I was asked to take a look at high cluster service privileged time usage and realized I had forgotten! I guess better late than never? If you’re using WSFC integrated AGs (cluster_type = WSFC) then the cluster database is the location in which availability […]
Issue Introduction I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to stop the service via services or the SQL Server Configuration Manager resulted in a timeout with SQL Server still running. Trying to execute the shutdown with and without NOWAIT T-SQL command resulted in the same, […]
Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read the intro to that first, otherwise you’ll be lost. Much as I’ve discussed before, SQL Server uses a cooperative scheduling model. This doesn’t mean that Windows does, nor does it mean Windows will scheduler whatever […]
Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL Server”, then I realized maybe this isn’t the case… So, I pondered over this question, “is it truly misunderstood?” and came to the (possibly incorrect) realization that it is quite accurate in the general SQL […]
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 […]
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 […]
