Skip to main content
Pure1 Support Portal

Microsoft SQL Server AlwaysOn Reference Architecture with Pure Storage

This document provides a reference architecture for deploying Microsoft SQL Server 2014 AlwaysOn Availability Groups on a Pure Storage FlashArray. This document includes step-by-step guidance on deploying a primary and disaster recovery site for high availability.

The primary site is based on a Windows Server Failover Cluster that will be used with a Microsoft SQL Server 2014 AlwaysOn Availability Group with two physical server nodes for the primary replica and secondary replica. Two virtualized Windows Server 2012 R2 nodes based on VMware ESX 5.5 will be created for two additional secondary replicas. The disaster recovery site is based on a Windows Server Failover Cluster to create a highly available Hyper-V instance for a SQL Server 2014 stand-alone server.

The primary site will use Pure Storage FlashRecover Replication to replicate the AlwaysOn Availability Group data volumes to the disaster recovery site to be used with the SQL Server 2014 stand-alone server. FlashRecover replication can easily replicate data volumes and maintain data synchronization based on a configurable schedule.

The attached PDF goes over how to locate Serial Numbers for FA-400 and FlashArray//m hardware.  You can download the PDF file here, or you can view the inline copy below:

If you are unable to see the PDF inline, you can click here to download the PDF file.