# SAP on AWS architecture patterns for Microsoft SQL server
<a name="patterns-microsoft"></a>

This document provides information about architecture patterns for deploying SAP workloads in AWS Cloud on Microsoft SQL servers. These patterns offer highly available and resilient implementation options while considering your recovery time and point objectives.

Work backwards from your business requirements to define an approach that meets the availability goals of your SAP systems and data. For each failure scenario, the resiliency requirements, acceptable data loss, and mean time to recover need to be proportionate to the criticality of the component and the supported business applications.

You can customize these patterns for your specific business criteria. You should consider the risk and impact of each failure type, and the cost of mitigation when choosing a pattern.

**Topics**
+ [Patterns](#patterns)
+ [Comparison matrix](#comparison)
+ [Single Region architecture patterns for Microsoft SQL server](single-region.md)
+ [Multi-Region patterns for Microsoft SQL server](multi-region.md)

## Patterns
<a name="patterns"></a>

The architecture patterns are divided into two categories.
+  [Single Region patterns](https://docs.aws.amazon.com/sap/latest/general/single-region.html) 
+  [Multi-Region patterns](https://docs.aws.amazon.com/sap/latest/general/multi-region.html) 

## Comparison matrix
<a name="comparison"></a>

The following table provides a comparison of all the architecture patterns discussed further.

[See the AWS documentation website for more details](http://docs.aws.amazon.com/sap/latest/general/patterns-microsoft.html)

 *\*To achieve near zero recovery point objective, database replication must be setup in synchronous data commit mode within the same AWS Region.*