Opinionated SQL
Search

Month: August 2020

HA/DR

Using Distributed Network Names with Availability Groups

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 […]

Read article: Using Distributed Network Names with Availability Groups
HA/DR

Attempting to recycle all monitors that have loaded the DLL sqsrvres.dll or hadrres.dll and you notice a SQL FCI/AG failed health checks

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, […]

Read article: Attempting to recycle all monitors that have loaded the DLL sqsrvres.dll or hadrres.dll and you notice a SQL FCI/AG failed health checks