Best Practices for Microsoft Architectures on AWS - 23 September - 11:00

Best Practices for Microsoft Architectures on AWS - 23 September - 11:00

• 1. Microsoft Workloadson AWS Microsoft Workloads on AWS Anil Erduran EMEA Microsoft Partner Solutions Architect Amazon Web Services anerdura@amazon.com
• 2. Windows momentum on AWS Windows momentum on AWS 11 Years Helping customers run and scale Windows Workloads in the cloud 400% Growth Between 2015 and 2018 of AWS enterprise customers using Amazon Elastic Compute Cloud (Amazon EC2) for Windows Server
• 3. The AWS advantage for Windows over the next largest cloud provider The AWS advantage for Windows over the next largest cloud provider
• 4. 11 years of innovation for Windows on AWS 11 years of innovation for Windows on AWS Customer Adoption 2008 2010 2012 2014 2016 2018 Today 143 instance types, 37 instance families 060 different AMIs for Windows workloads Visual Studio Toolkit Microsoft SCOM plug-in release. Microsoft SharePoint 2016 (Marketplace) Microsoft SCVMM Plug-in SAP instance on AWS 2012 Trusted Advisor checks for Windows Hyper-V support in SMS Windows for Lightsail Application-consistent Snapshots through VSS AWS Directory Service Sessions Manager Dedicated Host Enhancement Tag-On EC2 Dedicated Hosts (BYOL) EC2 Run Command EC2 Systems Manager EC2 Dedicated Instances (BYOL) EC2 Windows on Bare Metal/Hyper-V AMI WS 2008 & SQL Server 2008 Windows Server 2008 R2 Windows Server 2012 Windows Server 2016 Windows Server 1803 Windows Server 2003 SQL 2017 AMI AL2/Ubuntu SQL Server 2008 R2 Amazon RDS adds SQL Server SQL Server 2017 SQL Server 2012 SQL Server 2008 R2 SQL Server 2016 Windows Server & EC2 SQL Server .NET App Modernization .NET Core & Powershell on AL2/Ubuntu Windows Deep Learning AMI .NET Core 2.1 on Linux AMIs Lambda Support for PowerShell Core Amazon ECS for Windows Containers AWS Tools for Windows PowerShell .NET SDK DynamoDB Accelerator SDK for .NET .NET on Lambda & AWS CodeBuild .NET Core 2.1 Support with Lambda & X-Ray X-Ray .NET SDK .NET Developer Hub AWS X-Ray .NET Core Support .NET Developer Hub
• 5. Slide861 All Things Microsoft run great on AWS Advanced Threat Analytics BizTalk Core Infrastructure Suite R Server Microsoft Office Exchange Server Project Server SharePoint Server Skype for Business Server SQL Server System Center System Center Server Visual Studio Visual Studio Team Foundation Server Windows Desktop Enterprise Operating System Windows Server MSDN Remote Desktop Services Microsoft Dynamics
• 6. Reliability begins with the AWS Global Infrastructure Sāo Paulo GovCloud (US-West) Montréal N. Virginia GovCloud (US-East) Ireland London Paris Stockholm Bahrain Cape Town Mumbai Ningxia Beijing Singapore Hong Kong Seoul Tokyo Sydney Frankfurt Oregon N. California Milan Ohio 1 4 6 7 3 2 5 Reliability begins with the AWS Global Infrastructure Jakarta The AWS Cloud spans 69 Availability Zones within 22 geographic Regions around the world, with announced plans for 9 more Availability Zones and three more Regions in Cape Town, Jakarta, and Milan. Active Regions Announced Regions
• 7. AWS global reach AWS global reach 22 regions – 69 availability zones – 100+ edge locations
• 8. Slide758 High Availability in AWS Availability Zone-1 Availability Zone-2 Miles Apart Milliseconds Latency Workloads Workloads Clustering Load Balanced Application Storage Multi-Region Based Routing
• 9. Flexible options for Microsoft licenses in the AWS cloud Flexible options for Microsoft licenses in the AWS cloud 1.Flexible pay-as-you-go Microsoft licensing choices 2.Bring your Microsoft license mobility benefits to Amazon EC2 AWS Buy Microsoft license- included instances from AWS (Windows Server, SQL Server) Bring Microsoft licenses to Amazon EC2
• 10. Slide1110 •AWS Support engineers can escalate directly to Microsoft Support on behalf of AWS customers Premier support for AWS customers running Microsoft workloads
• 11. Active Directory on AWS Active Directory on AWS
• 12. Product listing: AD Connector, MAD, AD on EC2 Product listing: AD Connector, MAD, AD on EC2 AD Connector Managed AD AD on EC2 Connect Windows on EC2 and AWS apps to on-prem AD Managed AD designed to work with RDS and more Deploy self-managed AD on AWS
• 13. Stay in control with options during your migration Stay in control with options during your migration AD Connect Microsoft workloads on EC2 to your existing Active Directory using AD Connector Or “lift and shift” AD to AWS alongside EC2 workloads AD
• 14. AD on AWS: simplify and optimize AD on AWS AD on AWS: simplify and optimize AD on AWS AD AD Managed Active Directory Reduce admin costs of running AD over RDS, FSx, and Windows workloads on AWS Legacy Active Directory Continue to use traditional AD for your data center footprint; choose how to share permissions
• 15.  AWS Managed Microsoft AD AWS Managed Microsoft AD •AWS managed, actual Microsoft Active Directory •~3-click setup from directory service console or script through API •Min 2 DCs each in separate Availability Zones (AZ) •Scale-out with additional DCs •Automatic patching, replication, and daily snapshots •Compliance audited •750 hour free trial for new AWS Directory Service customers •Schema Extension and Domain Trust Support •New! Cross VPC/Account Support •New! External Trust Support
• 16. Migrating and modernizing SQL Server Workloads on AWS Migrating and modernizing SQL Server Workloads on AWS
• 17. SQL Server on AWS exhibited 2X+ better price/ performance than Azure (ZK Research) SQL Server on AWS exhibited 2X+ better price/ performance than Azure (ZK Research) SQL Server on Amazon EC2 consistently outperforms Azure across a variety of machine types https://zkresearch.com/blog/2018/11/comparing-sql-server-deployments-on-microsoft-azure-and-amazon-web-services *Results for Small and Medium configuration available on https://zkresearch.com, a 3rd party research firm
• 18. Options for deploying SQL Server on AWS Amazon RDS for SQL Server SQL Server on Amazon EC2 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 •Schema optimization •No in-house database expertise •Automatic Host Replacement •Need full control over DB instance •3rd party server agents •Clustering •Options that are not currently available in Amazon RDS Options for deploying SQL Server on AWS AWS managed Customer managed
• 19. Database “modernize” choices for Windows Workloads Database “modernize” choices for Windows Workloads Consistent user experience No change to apps Reduce costs of Windows license and support Integration with cloud native services Significant reduction in TCO DBA experience changes for better SQL Server on Amazon Aurora Linux
• 20. Slide1091 Microsoft SQL HA/DR On Premise (without AZ’s) Region/ DC1 Region/ DC2 On premise Synchronous Replication Asynchronous Replication §Requires three Node SQL Cluster §Manual failover between Regions §Downtime and loss of data during regional failover §Expensive and Complex 100’s Miles SQL Licencing is one of the largest components of an Enterprise Agreement List Price for 2 Cores of SQL Enterprise circa $13,000
• 21. Slide1092 Region AWS Multi-AZ Synchronous Replication §Up to 50% reduction in SQL costs §Automatic failover and recovery §Near zero down Time §Zero loss of data Availability Zone Availability Zone Miles Apart “We concluded that migrating to AWS would be the most cost-effective strategy, and the agility of the AWS Cloud model fit our SQL Server workloads perfectly,” Mike Gassner, Sony NMS video division. Microsoft SQL HA/DR On AWS (with AZ’s)
• 22. Cost savings improve through optimizations Cost savings improve through optimizations On- Premises Lift & Shift Instance Right-Sizing Improved Elasticity Measure, Monitor, Improve Optimized EC2 Storage Optimization Serverless Architecture Managed Services True AWS Optimized True TCO comparison Post migration cost savings Typical TCO comparison
• 23. SQL Server on Linux  SQL Server on Linux SAVE EVEN MORE WITH RI’S 20% lower cost Price per hour Choice: Ubuntu, RHEL, Amazon Linux 2 Standardization across one operating system
• 24. Windows to Linux re-platforming assistant for Microsoft SQL Server Databases © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Confidential and Trademark Windows to Linux re-platforming assistant for Microsoft SQL Server Databases üMoves Microsoft SQL Server workloads from Windows to a Linux operating system üWorks with any Windows Server virtual machine, in the cloud or on- premises and running SQL Server 2008 or above üChecks for common incompatibilities üExports SQL Server databases from the Windows VM, and imports into a Linux EC2 instance running SQL Server 2017 https://s3.amazonaws.com/sms- connector/Windows+to+Linux+replatforming+tool+for+Micros oft+SQL+server+databases.pdf
• 25. License optimization with Optimize CPUs License optimization with Optimize CPUs •Control active vCPUs and hyper-threading status when launching new EC2 instances •Reduce the number of SQL Server licenses *Sample licensing example only
• 26. Slide1075 Private Subnet Automatic Failover Managed Service RDS SQL Server – Managed SQL Server on AWS Power, HVAC, net OS install/maintenance OS patching DBMS install/maintenance DBMS patching Database backups High availability Scaling Availability Zone 1 Private Subnet Availability Zone 2 AWS Region Amazon RDS Primary Amazon RDS Secondary AWS managed
• 27. Amazon RDS is available for 6 different DB engines Amazon RDS is available for 6 different DB engines lets you deploy Microsoft enterprise workloads with Amazon RDS
• 28. Recent RDS SQL Server Announcements Recent RDS SQL Server Announcements •SQL Server Audit support •Audit Microsoft SQL Server databases by using the built-in SQL Server auditing mechanism. •Always On Availability Groups supported in Microsoft SQL Server 2017 •Amazon RDS Performance Insights is available for Amazon RDS for SQL Server •Amazon RDS for SQL Server Increases the Database Limit Per Database Instance up to 100
• 29. Migrating Windows Workloads Migrating Windows Workloads
• 30. The SQL 2008 EOS is here!  © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Confidential and Trademark The SQL 2008 EOS is here! 50-60% of On-Premises Microsoft workloads are running on 2008 versions No new patches or security updates means exposure to cyber attacks SQL Server 2008 and 2008 R2 Windows Server 2008 and 2008 R2 July 9, 2019 Jan 14, 2020 Risk of non-compliance with regulatory bodies and new legislation
• 31. SQL Server Upgrade Tool © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Confidential and Trademark SQL Server Upgrade Tool üAutomates SQL Server 2008 to SQL Server 2016 upgrades üCreates a SQL Server 2016 AMI from a SQL Server 2008 instance running on Windows EC2 üPerforms an in-place upgrade üTest application functionality in backwards compatibility mode https://docs.aws.amazon.com/systems- manager/latest/userguide/automation-awsec2- CloneInstanceAndUpgradeSQLServer.html
• 32. Migrating DatabasesImporting and Exporting SQL Server Databases  Migrating Databases Importing and Exporting SQL Server Databases •Migrate databases to Amazon RDS. •Move databases between Amazon RDS SQL Server DB instances. •Import and export data. •Migrate schemas, stored procedures, triggers and other database code. •Backup and restore single databases •Testing, training, and demonstrations. Amazon S3 Amazon RDS
• 33. What are AWS DMS and AWS SCT? What are AWS DMS and AWS SCT? AWS Database Migration Service (AWS DMS) easily and securely migrates and/or replicates your databases and data warehouses to AWS AWS Schema Conversion Tool (AWS SCT) converts your commercial database and data warehouse schemas to open-source engines or AWS-native services, such as Amazon Aurora and Amazon Redshift
• 34. When to use AWS DMS and AWS SCT?  When to use AWS DMS and AWS SCT? Modernize Migrate Replicate Modernize your database tier •Commercial to open-source •Commercial to Amazon Aurora Modernize your data warehouse •Commercial to Amazon Redshift •Migrate business-critical applications •Migrate from Classic to VPC •Migrate data warehouse to Amazon Redshift •Upgrade to a minor version •Consolidate shards into Aurora •Create cross-region Read Replicas •Run your analytics in the cloud •Keep your dev/test and production environment in sync
• 35. Slide1109 OLTP Conversions DW Conversions AWS Schema Conversion Tool
• 36. Migrating ServersAWS Server Migration Services Migrating Servers AWS Server Migration Services •Simplify the cloud migration process. •Orchestrate multi-server migrations •Test server migrations incrementally •Support the most widely used operating systems •VMware & Hyper-V support •Minimize downtime •Windows Server 2003 Support Azure to AWS migration support has been announced on 18 April 2019. Server Migration
• 37. 🚀 CloudEndure Migration Now Available at No Charge 🚀 CloudEndure Migration Now Available at No Charge https://migration-register.cloudendure.com/ •Each free license allows for 90 days of use following agent installation. •If they do not complete their migration within the free 90 days, they can open a new CloudEndure Migration account to begin another free 90-day period
• 38. Slide1135
• 39. Recent product releases Recent product releases
• 40. Amazon FSx for Windows File Server Amazon FSx for Windows File Server Lift and shift your Windows file storage with fully managed windows file servers Fully managed Fast and flexible performance Native Windows compatibility Broad accessibility Enterprise-ready
• 41. Native Windows compatibility and features Native Windows compatibility and features Native Windows compatibility DFS Namespaces and DFS Replication Integrates with Microsoft AD and supports Windows ACLs AD NTFS Windows Server Native SMB 2.0 to 3.1.1 SMB New: Shadow Copy is now supported for FSx for Windows File Server
• 42. AWS License Manager AWS License Manager A one-stop solution for managing licenses from a variety of software vendors Proactively stay compliant according to your organizational structure and processes Built-in integration with AWS Services Manage licenses across hybrid environments
• 43. License Manager enables hybrid IT licensing License Manager enables hybrid IT licensing Define rules for your licensed software from Microsoft, Oracle, IBM, SAP, and others Choose a license counting type: vCPU, physical cores, physical sockets, or number of instances Choose whether to enforce a license limit At-a-glance summary of licenses and usage limits See whether or not limits are enforced License Manager helps manage usage limits Windows Server on AWS IBM DB2 on AWS Oracle Database on AWS On-premises SQL Server Across cloud and on-premises
• 44. Fast start to AWS Fast start to AWS
• 45. The pieces come together Migration services and tools AWS Investment Migration methodology The pieces come together AWS Managed Services AWS Training and Certification AWS Partner Network AWS Professional Services
• 46. Work with experienced partners Work with experienced partners Microsoft competency partners +thousands of additional APN partners Migration partners
• 47. Slide1132 Questions Answers Anil Erduran EMEA Microsoft Partner Solutions Architect Amazon Web Services anerdura@amazon.com