Research Library

How To Guide: Building SQL Server AG with Optane

Published January 25th, 2023. A concise how-to guide for building SQL Server Always On Availability Group (SQL Server AG) solutions using Intel Optane NVMe. Download the full how-to guide now!

Hands-On SQL Server HA

The steps outlined and recommendations contained in this guide are based upon hands-on experience combined with Microsoft “Best Practices” recommendations.

SQL Server AG

A SQL Server Always On Availability Group (SQL Server AG) supports one or more replicas, with the ability to failover one or more databases to another system. Data consistency between instances may use asynchronous replication for high-performance or long distance, or synchronous replication for no data loss failovers, aka zero recovery point objective (RPO) database failovers.

SQL Server AG is similar in concept to replication or mirroring but provides more features and options, such as multiple copies, sync and async replication and more. Additionally, by operating at the application level, SQL AG can ensure application-level consistency of data, unlike solutions that operate logically below the application, at the OS or storage layer.

SQL Server AG relies upon failover capabilities within Windows Server Failover Clustering (WSFC) technology together with features in SQL Server (since SQL 2012). Windows clustering does not require shared storage (with Server 2016+), using two or more Windows Server instances, each with SQL Server.


Register or login to download this Free document

Forgot your password? Reset it here.