The Curious Engineer

All blogs / Databases

AlwaysOn Professional

learn.microsoft.com/en-us/archive/blogs/alwaysonpro

Home of the Microsoft SQL Server AlwaysOn Support Team

DatabasesDistributed systems / cloudMicrosoft blogsMSDN archive

’15’20’25
Posts
56 from 28 Jun 2013 to 6 Feb 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/alwaysonpro/feed.xml

2018 1

  1. Analyze Synchronous Commit Impact on High Commit Rate Workloads

2017 6

  1. Analyze Network Latency Impact on Remote Availability Group Replica
  2. Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible
  3. Avoid Availability Group Database Data Loss: Do not Deploy File Share Witness From DFS Namespace
  4. Troubleshooting Internal Load Balancer Listener Connectivity in Azure
  5. How to Apply Transaction Logs to Secondary When it is Far Behind
  6. Making Service Broker Application Highly Available With AlwaysOn

2016 9

  1. AlwaysOn Readable Secondaries Can Display Misleading Data & Log File Paths
  2. SQL Server 2016 AlwaysOn Availability Group Enhancements: Support for Encrypted Databases
  3. SQL Server 2016 AlwaysOn Availability Group Enhancements: Multiple Automatic Failover Targets
  4. SQL Server 2016 AlwaysOn Availability Group Enhancements: Load Balance Read-Only Routing
  5. SQL Server 2016 AlwaysOn Availability Group Enhancements: Initial Data Synchronization Without Database and Log Backup
  6. SQL Server 2016 AlwaysOn Availability Group Enhancements: Basic Availability Group on Standard Edition
  7. Improved AlwaysOn Availability Group Lease Timeout Diagnostics
  8. Troubleshooting Availability Group Listener in Azure
  9. Enhance AlwaysOn Failover Policy to Test SQL Server Database Data and Log Drives

2015 7

  1. Replication Agents fail to connect to listener in a multisite cluster
  2. Failing back from DR site after primary site is back online
  3. AlwaysOn Availability Group Listener Cannot be Created or Failed Over on Node if 'Primary DNS suffix' is not set
  4. AlwaysOn Availability Group Returns Failover Partner for Legacy Mirror Application Connectivity
  5. Recommendations for Index Maintenance with AlwaysOn Availability Groups
  6. How to add a TDE encrypted database to an Availability Group
  7. Troubleshooting REDO queue build-up (data latency issues) on AlwaysOn Readable Secondary Replicas using the WAIT_INFO Extended Event

2014 22

  1. Diagnose Unexpected Failover or Availability Group in RESOLVING State
  2. Large Transaction Interrupted by Failover, Secondary Database Reports REVERTING
  3. Troubleshooting the Add Azure Replica Wizard in SQL Server 2014
  4. Determine Availability Group Synchronization State, Minimize Data Loss When Quorum is Forced
  5. Enhance AlwaysOn Failover Policy to Test SQL Server Responsiveness
  6. Recommendations and Best Practices When Deploying SQL Server AlwaysOn Availability Groups in Microsoft Azure (IaaS)
  7. Connection Timeouts in Multi-subnet Availability Group
  8. IaaS with SQL AlwaysOn - Tuning Failover Cluster Network Thresholds
  9. Create Azure Listener fails with "Unable to save property changes for <cluster resource name> The parameter is incorrect"
  10. Use ReadIntent Routing with Azure AlwaysOn Availability Group Listener
  11. Create Listener Fails with Message 'The WSFC cluster could not bring the Network Name resource online'
  12. Manual Failover of Availability Group to Disaster Recovery site in Multi-Site Cluster
  13. SQL Server manages Preferred and Possible Owner Properties for AlwaysOn Availability Group/Role
  14. How to map logins or use contained SQL database user to connect to other replicas and map to availability databases
  15. Issue: Replica Unexpectedly Dropped in Availability Group
  16. Setting up Replication on a database that is part of an AlwaysOn Availability Group
  17. How to enable TDE Encryption on a database in an Availability Group
  18. Reducing Loss of Connectivity when Recreating an Availability Group
  19. Modifying AlwaysOn Read Only Routing Lists
  20. MSDTC Recommendations on SQL Failover Cluster
  21. Not-Supported: AGs With DTC/Cross-Database Transactions
  22. Maintenance Plan Does not Backup Database or Log of Database Defined in Availability Group

2013 11

  1. Create Availability Group Fails With Error 35250 'Failed to join the database'
  2. Recovery On Secondary Lagging – Shared Redo Target
  3. How It Works: SQL Server AlwaysOn Lease Timeout
  4. Configure Availability Group to Communicate on a Dedicated Network
  5. Create Availability Group Listener Fails with Message 19471, ‘The WSFC cluster could not bring the Network Name resource online’
  6. SQLPass 2013 Presentation "Enterprise High Availability with AlwaysOn Availability Groups [DBA-398-P]"
  7. Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas - Part 1
  8. LooksAlive and IsAlive Implementation of Availability Groups failure_condition_level
  9. Connect to SQL Server Using Application Intent Read-Only
  10. End to End - Using a Listener to Connect to a Secondary Replica (Read-Only Routing)
  11. AlwaysOn Availability Groups Troubleshooting and Monitoring Guide