Best Practices for Deploying Microsoft SQL Server on ...

Best Practices for Deploying Microsoft SQL Server on Amazon EC2

First Published September 2018 Updated July 28, 2021

This version has been archived.

For the latest version of this document, visit:

best-practices-for-deploying-microsoft-sql-server/

best-practices-for-deploying-microsoft-sqlserver.html

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.

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

This version has been archived.

For the latest version of this document, visit:

best-practices-for-deploying-microsoft-sql-server/

best-practices-for-deploying-microsoft-sqlserver.html

Contents

Introduction ..........................................................................................................................1 High availability and disaster recovery ...............................................................................2

Availability Zones and multi-AZ deployment ...................................................................3 Using AWS Launch Wizard to deploy Microsoft SQL Server on Amazon EC2 instances 5

Multi-Region deployments ...............................................................................................6 Disaster recovery .............................................................................................................8 Performance optimization..................................................................................................10 Using Amazon Elastic Block Store (Amazon EBS) .......................................................10 Instance storage.............................................................................................................11 Amazon FSx for Windows File Server...........................................................................13 Bandwidth and latency...................................................................................................13 Read replicas..................................................................................................................14 Security optimization .........................................................................................................15 Amazon VPC..................................................................................................................15 Encryption at rest ...........................................................................................................15 Encryption in transit........................................................................................................16

Encryption in use........T...h...i.s....v..e...r..s..i..o...n....h...a...s...b...e...e..n.....a..r..c...h...i.v...e...d.................................16

AWS Key Management Service (AWS KMS) ...............................................................16

Security patcheFso...r...t..h...e....l.a..t..e...s..t...v...e..r..s..i..o..n.....o...f...t..h..i..s...d...o...c..u...m....e...n...t..,..v...i.s..i.t..:..............16

Cost optimization ...............................................................................................................17 Using SQL Server Developer Edition for non-production .............................................17

Amazon ECh2tCtpPsU:/o/pdtiomcizsa.atiowns....a...m...a...z..o...n....c..o...m..../..w....h..i.t..e..p...a..p...e..r..s../..l..a..t..e..s..t../...............18 best-practices-for-deploying-microsoft-sql-server/

Switch to SQL Sberevsetr-SptraancdtaircdeEsd-fitoiorn-d...e..p...l.o...y..i.n...g...-.m....i..c..r.o...s..o..f..t..-.s..q...l.-.......................18 Z1d and R5b EC2 instance types.....s..e..r..v..e...r...h..t..m....l.......................................................19

Eliminating active replica licenses .................................................................................20 SQL Server on Linux .........................................................................................................22

Operational excellence......................................................................................................23 Observability and root cause analysis ...........................................................................23 Reducing mean time to resolution (MTTR) ...................................................................24 Patch management ........................................................................................................24

Contributors .......................................................................................................................25 Document revisions...........................................................................................................25

This version has been archived. For the latest version of this document, visit:

best-practices-for-deploying-microsoft-sql-server/

best-practices-for-deploying-microsoft-sqlserver.html

Abstract

This whitepaper focuses on best practices to attain the most value for the least cost when running Microsoft SQL Server on AWS. Although, for many general-purpose use cases, Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server (MS SQL) provides an easy and quick solution, this paper focuses on scenarios where you need to push the limits to satisfy your special requirements.

In particular, this paper explains how you can minimize your costs, maximize availability of your SQL Server databases, optimize your infrastructure for maximum performance, and tighten it for security compliance, while enabling operational excellence for ongoing maintenance. The flexibility of AWS services, combined with the power of Microsoft SQL Server, can provide expanded capabilities for those who seek innovative approaches to optimize their applications and transform their businesses.

The main focus of this paper is on the capabilities available in Microsoft SQL Server 2019, which is the most current version at the time of this publication. Existing databases that run on previous versions (2008, 2012, 2014, 2016, and 2017) can be migrated to SQL Server 2019 and run in compatibility mode.

Mainstream and extended support for SQL Server 2000, 2005, and 2008 has been discontinued by Microsoft. Any database running on those versions of SQL Server must be upgraded to a supported version first. Although it is possible to run those versions of SQL Server on AWS, that discussion is outside the scope of this whitepaper.

This version has been archived.

For the latest version of this document, visit:

best-practices-for-deploying-microsoft-sql-server/

best-practices-for-deploying-microsoft-sqlserver.html

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

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

Google Online Preview   Download