AlwaysOn Availability Group Listener Cannot be Created or Failed Over on Node if ‘Primary DNS suffix’ is not set

AlwaysOn availability groups will not function properly on Windows servers where the system’s ‘Primary DNS Suffix of this Computer’ is not set. Usually, the Primary DNS Suffix is populated when a Windows server joins a domain. Create Listener on Windows server without ‘Primary DNS suffix’ fails Attempting to create the availability group listener will fail…


AlwaysOn Availability Group Returns Failover Partner for Legacy Mirror Application Connectivity

Availability Groups Simulate Database Mirroring Connection Behavior Given the following scenario, SQL Server will return the failover partner server name to a connection request: The availability group has a single secondary replica. The availability group replicas have ALLOW_CONNECTIONS set to NO or READ_ONLY. The client application makes a successful initial connection to the primary replica….


Recommendations for Index Maintenance with AlwaysOn Availability Groups

  SYMPTOMS Consider the following scenario The database is part of AlwaysOn Availability Groups You run long and log-intensive transactions like Index maintenance/rebuilds You observe one or more of the following symptoms: Poor performing DML operations in availability databases on the primary replica if synchronous secondary replicas are present. Huge log send queue in the…