aws services for windows workloads...amazon rds amazon ec2 type size performance size performance...

© 2020, Amazon Web Services, Inc. or its Affiliates. All rights reserved.© 2020, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Dai Truong, Partner Solutions [email protected]

AWS services for Windows Workloads

© 2020, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Agenda

• Running SQL Server on RDS/EC2• Active Directory Integration• Deploy and Manage SQL Server• Amazon FSx file system• AWS License Manager


Choose the best service for your needs

Amazon EC2

AmazonRDS

Amazon RDS SQL Server

Your Responsibility:• App Optimization and

Tuning• Deployment

Orchestration

SQL Server on Amazon EC2

Your Responsibility:• App Optimization and

Tuning• Deployment

Orchestration• Monitoring and Recovery• High Availability• Backups• DB & OS Patching

Evaluation


Choose the best service for your needs

Amazon EC2

AmazonRDS

Amazon RDS SQL Server

Cloud-native solution

Focus on:• Business value tasks• High-level tuning tasks• Schema optimization

No in-house database expertise

SQL Server on Amazon EC2

Need control over:• DB instance & OS• Backups, Replication• Clustering• sysadmin role

Need to use features, size or performance options not available in Amazon RDS

Evaluation


Amazon RDS for SQL Server SQL Server on Amazon EC2

Customer managedAWS managed

Power, HVAC, net

OS Install/Maintenance

OS Patching

DBMS Install/Maintenance

DBMS Patching

Database Backups

High Availability

Scaling

Power, HVAC, net

OS Install/Maintenance

OS Patching

DBMS Install/Maintenance

DBMS Patching

Database Backups

High Availability

Scaling

• Consider RDS first• Focus on business

value tasks

• High-level tuning asks

• Schema optimization

• No in-house database expertise

• Need full control overDB instance

• Backups

• Replication

• Clustering

• Options that are notavailable in RDS

Options for Deploying SQL Server on AWS


SQL Server Features at a Glance

2008R2, 2012, 2014, 2016, 2017Versions Supported:

Editions Supported:

High Availability:

Encryption:

Authentication:

Backups:

Maintenance:

Express, Web, Standard, Enterprise

All**

All**

AWS-managed

Encrypted Storage using AWS KMS (all editions); TDE Support

Self-managed; AlwaysOn, Mirroring…

Windows & SQL Authentication

Managed Automated Backups Maintenance Plans & 3rd Party Tools

Automated Software Patching Self-managed

Amazon RDS Amazon EC2


Storage & I/O Performance

Amazon RDS Amazon EC2Type Size Performance Size Performance Burst Capacity Pricing Model

General Purpose (SSD)

20 GiB–16 TiB(min. 100 GiBrecommended)

3 IOPS/GiB for volumes 1 TiBor less, up to 16,000 IOPS for larger volumes

1 GiB–16 TiB 3 IOPS/GiB for volumes 1 TiB or less, up to 16,000 IOPS for larger volumes

Yes, up to 3000 IOPS per volume, subject to credits (< 1 TiB in size)

Allocated storage

Provisioned IOPS(SSD)

100 GiB–16 TiB Up to max. 32,000 IOPS*

4 GiB–16 TiB Up to 64,000 IOPS

No, fixed allocation

Allocated storage; ProvisionedIOPS


Multi-AZ SQL Server on Amazon RDS


Active Directory Integration


Integrate with Amazon Directory Service

• Cloud-based Active Directory deployment using AWS Directory Services Microsoft AD

• Managed directory• Credentials stored and managed

in the directory• RDS DB instance joined to the

directory operated domain• Add SQL Server logins for

domain users, and authenticate using Windows Authentication virtual private cloud

RDS SQL Server

Enabled forWindows

Authentication

Amazon Directory Service


Windows Authentication Using On-Prem AD

1. Setup Managed AD

2. Setup RDS

3. Enable Windows Integrated Authentication to use Managed AD directory

4. Create a Trust with On-Premises Domain

5. Assign privileges to On-Premises for access to RDS


Deploy and Manage SQL Server


Performance Insights for RDS SQL Server


Automated BackupsPoint-in-time recovery for your DB instance

• Scheduled daily volume backup of entire instance

• Archive database change logs• 35–day maximum retention • Minimal impact on database

performance

Every day during your backup window, RDS creates a storage volume snapshot of your instance

Every five minutes, RDS backs up the transaction logs of your database


Securing SQL Server on AWS: network

Amazon VPC: Control subnets, AZ specificity (DB subnet groups), route tables and NACLs

Security groups: Restrict instance traffic

Public access: Avoid it or limit it

1

2

3

VPC

4 Encrypt Traffic: Forced SSL supported


Securing SQL Server on AWS: data

Protect data at restEncrypted DB instances using AWS KMS,TDE, column-level, encrypt before saving

Secure data in transitEncrypted connections via SSL, forced SSL supported

1

2


Migrating Data to & from Amazon RDS

.BAK File Save & RestoreLeverages SQL Server’s native backup functionality

AWS Database Migration ServiceMinimize downtime during migrations, migrate between different DB platforms, Schema Conversion Tool

AWS MarketplaceThird-party data import and export tools and solutions

1

3

4

Microsoft SQL Server Database Publishing Wizard, Import/ExportExport to T-SQL files, load using sqlcmd

2

SQL Server ReplicationPush subscriptions to transactional replication

5


Amazon FSx file system


What is Amazon FSx for Windows File Server?

Manage hardware

Plan capacity

Procure and purchase hardware

Set up storage servers and volumes

Detect and address hardware failures

Invest CapEx

Manage software

Install and configure server software

Set up and configure file systems

Apply Windows updates

Manage software licenses

Manage backups

Monitor security

Fully managed native Windows file systems Fully managed means you no longer need to…


Creating an Amazon FSx file system


Simplify Cost and Complexity for SQL FCI using Amazon FSx for Windows File Server

PreviouslyNo Native Shared Storage Option on AWS

Required 3rd party solutions

SQL DB Primary

SQL DB Replica

AWS Cloud

Availability Zone 1 Availability Zone 2

Windows ServerFailover Clustering

(WSFC)

Shared Storage

Amazon FSxSimple, Fully Managed Windows File Share

Provides HA and DR

SQL DB Primary

SQL DB Replica

AWS Cloud

Availability Zone 1 Availability Zone 2

Windows ServerFailover Clustering

(WSFC)

Amazon FSx for Windows File Server Multi-AZWith Continuous Availabilty


AWS License Manager


Easily track licenses using AWS License Manager

Emulate licensing terms

as rules

Enforce licensing rules, stay compliant, and

control overages

Centrally report usage

1 2 3


Leverage built-in dashboard


Thank you

aws services for windows workloads...amazon rds amazon ec2 type size performance size performance...

Documents