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…