I’ve been asked this question a few times, so I feel it’s worth writing about, which is, “Are Distributed Network Names (DNN) supported for SQL Server?”. The short version is, it’s not supported. The long version is, it’s not supported, but if you’re using a vanilla AG (not distributed) and aren’t using things like replication […]
I won’t say I told you so… I will, however, point out common AG question #8… I’m not sure why so many of these are coming up lately, but I’ve not had to troubleshoot a few, and I think it’s worth documenting this behavior. Let’s say you have Windows cluster which might have FCI’s, AG’s, […]
This is inspired by all the times I am forced to repeat myself. To cut down on hearing my own horrible sounding voice, I present to you a FAQ style post of all things Availability Group related that I am consistently asked. Last updated June 25th, 2020. Q1: What’s the limit of databases I can […]
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 […]
Refresher It may be news (or not) to you that SQL Server can utilize the latest transport security standards when talking to clients and servers. Normally you’d need to create your own certificate for use with said standard protocols, but SQL Server is super nice and will create one for you, self-signed, and use that […]
The road to Hell is paved with good intentions. I get it, your security team is the best ever. You work at a company where the industry (or public sector) requires that servers be “compliant” by constantly and incessantly scanning them for vulnerabilities, in production of course. I know for some it checks a required […]
I had initially wrote this post with a great deal of information, but it came across as snarky and condescending which was not my original intention. Thus I’ve rewritten it in the hopes that it’s succinct and distilled down the the minimal amount of information needed to make an informed decision. This post is specifically […]
There has, for whatever reason, been a recent craze to figure out if a certain replica does or does not have the availability group create database permission. This is the permission that allows for automatic seeding to take place on the replica that is part of the availability group. I don’t quite understand the need. […]
Migrations from Windows Server 2008/R2 must be in full swing as there seems to be quite the buzz that SQL Server uses the sIDHistory attribute in Active Directory and they can migrate away with naught another thought. To set the background for this, Active Directory administrators have had an attribute that some applications have been […]
