AlwaysOn Professional
Home of the Microsoft SQL Server AlwaysOn Support Team
Analyze Synchronous Commit Impact on High Commit Rate Workloads
Workloads that rely on auto-commit (each operation like an INSERT has an implied, corresponding...
Author: AlwaysOn Professionals Date: 02/06/2018
Analyze Network Latency Impact on Remote Availability Group Replica
Multisite availability groups allow customers to deploy copies of business data across multiple...
Author: AlwaysOn Professionals Date: 12/21/2017
Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible
You may find that one or more availability group databases is reported ‘Not Synchronizing / Recovery...
Author: AlwaysOn Professionals Date: 11/29/2017
Avoid Availability Group Database Data Loss: Do not Deploy File Share Witness From DFS Namespace
Cluster Quorum File Share Witness Should Not be Part of a DFS Namespace When deploying AlwaysOn...
Author: AlwaysOn Professionals Date: 08/29/2017
Troubleshooting Internal Load Balancer Listener Connectivity in Azure
Problem Unable to Connect to Azure availability group listener Creating an availability group in...
Author: AlwaysOn Professionals Date: 02/22/2017
How to Apply Transaction Logs to Secondary When it is Far Behind
Problem Large Send Queue You discover that the log send queue for a given availability database has...
Author: AlwaysOn Professionals Date: 02/22/2017
Making Service Broker Application Highly Available With AlwaysOn
If you have a Service Broker (SSB) application connecting to SQL Server using an AlwaysOn...
Author: AlwaysOn Professionals Date: 01/26/2017
AlwaysOn Readable Secondaries Can Display Misleading Data & Log File Paths
Written By: Grant Carter, Senior Premier Field Engineer Reviewed By: Mark Weber – Principal Premier...
Author: AlwaysOn Professionals Date: 06/29/2016
SQL Server 2016 AlwaysOn Availability Group Enhancements: Support for Encrypted Databases
Overview In SQL Server 2012 and SQL Server 2014, encrypted databases could be added to an AlwaysOn...
Author: AlwaysOn Professionals Date: 06/23/2016
SQL Server 2016 AlwaysOn Availability Group Enhancements: Multiple Automatic Failover Targets
Overview SQL Server 2104 and SQL Server 2012 can have two synchronous secondary replicas. One...
Author: AlwaysOn Professionals Date: 05/02/2016
SQL Server 2016 AlwaysOn Availability Group Enhancements: Load Balance Read-Only Routing
Overview SQL Server 2104 and SQL 2012 read-only routing directed traffic to the first available...
Author: AlwaysOn Professionals Date: 05/02/2016
SQL Server 2016 AlwaysOn Availability Group Enhancements: Initial Data Synchronization Without Database and Log Backup
Overview In SQL Server 2012 and 2014, initializing a secondary replica is cumbersome to do manually,...
Author: AlwaysOn Professionals Date: 05/02/2016
SQL Server 2016 AlwaysOn Availability Group Enhancements: Basic Availability Group on Standard Edition
Basic Availability Group on Standard Edition Historically, SQL Server database mirroring offered...
Author: AlwaysOn Professionals Date: 05/02/2016
Improved AlwaysOn Availability Group Lease Timeout Diagnostics
When your AlwaysOn availability group is configured for automatic failover, you may find your...
Author: AlwaysOn Professionals Date: 02/23/2016
Troubleshooting Availability Group Listener in Azure
Configuring an availability group listener in Azure has additional steps involved when compared to...
Author: AlwaysOn Professionals Date: 02/01/2016
Enhance AlwaysOn Failover Policy to Test SQL Server Database Data and Log Drives
In SQL Server 2012 and 2014, AlwaysOn health diagnostics detect the health of the SQL Server process...
Author: AlwaysOn Professionals Date: 01/14/2016
Replication Agents fail to connect to listener in a multisite cluster
A listener (network name) for a multisite cluster will be dependent on more than 1 ip address. ...
Author: AlwaysOn Professionals Date: 04/27/2015
Failing back from DR site after primary site is back online
Assume steps similar to those from Manual Failover of Availability Group were used to move to the DR...
Author: AlwaysOn Professionals Date: 04/27/2015
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...
Author: AlwaysOn Professionals Date: 03/16/2015
AlwaysOn Availability Group Returns Failover Partner for Legacy Mirror Application Connectivity
Availability Groups Simulate Database Mirroring Connection Behavior Given the following scenario,...
Author: AlwaysOn Professionals Date: 03/06/2015
Recommendations for Index Maintenance with AlwaysOn Availability Groups
SYMPTOMS Consider the following scenario The database is part of AlwaysOn Availability Groups You...
Author: AlwaysOn Professionals Date: 03/03/2015
How to add a TDE encrypted database to an Availability Group
By default, the Add Database Wizard and New Availability Group Wizard for AlwaysOn Availability...
Author: AlwaysOn Professionals Date: 01/07/2015
Troubleshooting REDO queue build-up (data latency issues) on AlwaysOn Readable Secondary Replicas using the WAIT_INFO Extended Event
PROBLEM You have confirmed excessive build up of REDO queue on an AlwaysOn Availability Group...
Author: AlwaysOn Professionals Date: 01/06/2015
Diagnose Unexpected Failover or Availability Group in RESOLVING State
AlwaysOn availability groups use Windows Cluster to 1) detect the health of the SQL Server process...
Author: AlwaysOn Professionals Date: 11/26/2014
Large Transaction Interrupted by Failover, Secondary Database Reports REVERTING
If a large transaction in an availability database on the primary replica is interrupted by a...
Author: AlwaysOn Professionals Date: 11/25/2014
Troubleshooting the Add Azure Replica Wizard in SQL Server 2014
SQL Server 2014 introduced a new feature that automates the creation of a new AlwaysOn replica...
Author: AlwaysOn Professionals Date: 11/21/2014
Determine Availability Group Synchronization State, Minimize Data Loss When Quorum is Forced
When Windows Cluster quorum is lost either due to a short term network issue, or a disaster causes...
Author: AlwaysOn Professionals Date: 11/11/2014
Enhance AlwaysOn Failover Policy to Test SQL Server Responsiveness
The AlwaysOn failover policy for AlwaysOn availability groups monitors the health of the SQL Server...
Author: AlwaysOn Professionals Date: 10/13/2014
Recommendations and Best Practices When Deploying SQL Server AlwaysOn Availability Groups in Microsoft Azure (IaaS)
Introduction Microsoft Azure virtual machines (VMs) with SQL Server can help lower the cost of a...
Author: AlwaysOn Professionals Date: 08/29/2014
Connection Timeouts in Multi-subnet Availability Group
THE DEFINITION One of the issues that generates a lot of call volume we see on the AlwaysOn team is...
Author: AlwaysOn Professionals Date: 06/03/2014
IaaS with SQL AlwaysOn - Tuning Failover Cluster Network Thresholds
Symptom When running Windows Failover Cluster nodes in IaaS with SQL Server AlwaysOn, changing the...
Author: AlwaysOn Professionals Date: 06/02/2014
Create Azure Listener fails with "Unable to save property changes for The parameter is incorrect"
Symptom When creating a listener for an availability group hosted in Windows Azure virtual machines,...
Author: AlwaysOn Professionals Date: 05/22/2014
Use ReadIntent Routing with Azure AlwaysOn Availability Group Listener
The AlwaysOn availability group listener is supported in Windows Azure virtual machines (VMs), but...
Author: AlwaysOn Professionals Date: 03/31/2014
Create Listener Fails with Message 'The WSFC cluster could not bring the Network Name resource online'
One of the most common configuration issues customers encounter is availability group listener...
Author: AlwaysOn Professionals Date: 03/25/2014
Manual Failover of Availability Group to Disaster Recovery site in Multi-Site Cluster
Setting up an Always On availability group in a multi-site cluster for disaster recovery (DR)...
Author: George_Mason Date: 03/04/2014
SQL Server manages Preferred and Possible Owner Properties for AlwaysOn Availability Group/Role
As a clustered resource, the availability group clustered resource/role have configurable cluster...
Author: AlwaysOn Professionals Date: 02/28/2014
How to map logins or use contained SQL database user to connect to other replicas and map to availability databases
Assume a working AlwaysOn environment with an availability group. Suppose this availability group is...
Author: AlwaysOn Professionals Date: 02/19/2014
Issue: Replica Unexpectedly Dropped in Availability Group
You have deployed AlwaysOn availability groups and observe that one of the replicas unexpectedly...
Author: AlwaysOn Professionals Date: 02/03/2014
Setting up Replication on a database that is part of an AlwaysOn Availability Group
This blog post gives detailed steps on setting up Transactional replication on a database that is...
Author: AlwaysOn Professionals Date: 01/30/2014
How to enable TDE Encryption on a database in an Availability Group
By default, the Add Database Wizard and New Availability Group Wizard for AlwaysOn Availability...
Author: AlwaysOn Professionals Date: 01/28/2014
Reducing Loss of Connectivity when Recreating an Availability Group
When you drop an availability group, the listener resource is also dropped and interrupts...
Author: AlwaysOn Professionals Date: 01/23/2014
Modifying AlwaysOn Read Only Routing Lists
There are several good references that show how to create a Read Only Routing List for an AlwaysOn...
Author: AlwaysOn Professionals Date: 01/22/2014
MSDTC Recommendations on SQL Failover Cluster
The purpose of the following FAQ (Frequently Asked Questions) is to address common questions with...
Author: Shon Hauck Date: 01/15/2014
Not-Supported: AGs With DTC/Cross-Database Transactions
When the topic of cross-database and/or DTC transaction support, under an Availability Group, comes...
Author: AlwaysOn Professionals Date: 01/06/2014
Maintenance Plan Does not Backup Database or Log of Database Defined in Availability Group
Maintenance plans can be created in SQL Server Management Studio to schedule periodic database and...
Author: AlwaysOn Professionals Date: 01/02/2014
Create Availability Group Fails With Error 35250 'Failed to join the database'
You can create an availability group using the New Availability Group wizard or using a series of...
Author: AlwaysOn Professionals Date: 12/09/2013
Recovery On Secondary Lagging – Shared Redo Target
There are various reasons a secondary may not be keeping up (slow network, blocked redo worker by a...
Author: AlwaysOn Professionals Date: 12/04/2013
How It Works: SQL Server AlwaysOn Lease Timeout
The LeaseTimeout controls the lease mechanism and when the lease expires there is a very high...
Author: AlwaysOn Professionals Date: 11/15/2013
Configure Availability Group to Communicate on a Dedicated Network
SQL Server 2012 AlwaysOn Availability Groups uses a database mirroring endpoint for each SQL Server...
Author: AlwaysOn Professionals Date: 11/01/2013
Create Availability Group Listener Fails with Message 19471, ‘The WSFC cluster could not bring the Network Name resource online’
When trying to create an availability group listener, SQL Server may fail and report the following...
Author: AlwaysOn Professionals Date: 10/30/2013