Microsoft SQL Server high availability features can be enhanced by adding PowerStore metro node Local. Whether SQL Server is deployed as a standalone instance, a Failover Cluster Instance (FCI), or Always On Availability Group (AG), each deployment model can benefit from added storage resiliency.
A simple architecture diagram illustrates how a basic SQL Server configuration is enhanced with PowerStore metro node Local.
Figure 4. Basic SQL Server configuration with PowerStore metro node Local
Adding metro node to the SQL Server FCI storage architecture adds additional resiliency and can prevent cluster failover due to storage related events, both planned and unplanned. In this architecture, the shared storage requirement of an FCI is provided by metro node and enhanced with nondisruptive array failover.
Figure 5. WSFC storage configuration with metro node Local
Always On Availability Group architectures can benefit from metro node as well. Adding PowerStore metro node to the storage architecture allows nondisruptive storage failover to a secondary array to occur without initiating an AG failover that would occur with a single array.
Figure 6. AG storage configuration with metro node Local