Deploying Microsoft SQL Server on Amazon Web Services

Deploying Microsoft SQL Server on Amazon Web Services

Archived This paper has been archived. November 2019 For the latest technical content about the AWS Cloud, see the AWS Whitepapers & Guides page:



Notices

Customers are responsible for making their own independent assessment of the information in this document. This document: (a) is for informational purposes only, (b) represents current AWS product offerings and practices, which are subject to change without notice, and (c) does not create any commitments or assurances from AWS and its affiliates, suppliers or licensors. AWS products or services are provided "as is" without warranties, representations, or conditions of any kind, whether express or implied. The responsibilities and liabilities of AWS to its customers are controlled by AWS agreements, and this document is not part of, nor does it modify, any agreement between AWS and its customers.

Archived ? 2019 Amazon Web Services, Inc. or its affiliates. All rights reserved.

Contents

Introduction ..........................................................................................................................1 Amazon RDS for SQL Server ..........................................................................................1 SQL Server on Amazon EC2...........................................................................................1 Hybrid Scenarios ..............................................................................................................2

Choosing Between Microsoft SQL Server Solutions on AWS ...........................................2 Amazon RDS for Microsoft SQL Server .............................................................................4

Archived Starting an Amazon RDS for SQL Server Instance ........................................................5

Security ............................................................................................................................. 6 Performance Management ............................................................................................11 High Availability ..............................................................................................................15 Monitoring and Management .........................................................................................17 Managing Cost ...............................................................................................................21 Microsoft SQL Server on Amazon EC2 ............................................................................23 Starting a SQL Server Instance on Amazon EC2 .........................................................23 Amazon EC2 Security ....................................................................................................25 Performance Management ............................................................................................26 High Availability ..............................................................................................................29 Monitoring and Management .........................................................................................32 Managing Cost ...............................................................................................................34 Caching ..............................................................................................................................36 Hybrid Scenarios and Data Migration ...............................................................................37 Backups to the Cloud .....................................................................................................38 SQL Server Log Shipping Between On-Premises and Amazon EC2 ..........................39 SQL Server Always On Availability Groups Between On-Premises and Amazon EC2 ........................................................................................................................................ 40 AWS Database Migration Service .................................................................................42 Comparison of Microsoft SQL Server Feature Availability on AWS ................................42

Conclusion .........................................................................................................................46 Contributors .......................................................................................................................46 Further Reading.................................................................................................................47 Document Revisions..........................................................................................................47

Archived

Abstract

This whitepaper explains how you can run SQL Server databases on either Amazon Relational Database Service (Amazon RDS) or Amazon Elastic Compute Cloud (Amazon EC2) and the advantages of each approach. We review in detail how to provision and monitor your SQL Server database, and how to manage scalability, performance, backup and recovery, high availability, and security in both Amazon RDS and Amazon EC2.

We also describe how you can set up a disaster recovery solution between an onpremises SQL Server environment and AWS, using native SQL Server features like log

Archived shipping, replication, and Always On availability groups. This whitepaper helps you

make an educated decision and choose the solution that best fits your needs.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download