sql server konferenz 2017 azure vs. amazon rds.pdf · mvp –data platform [+4 years | based in...
TRANSCRIPT
![Page 1: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/1.jpg)
SQL Server Konferenz 2017
Azure SQL Database Vs.
Amazon RDS
![Page 2: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/2.jpg)
MVP – Data Platform [+4 Years | Based in Brazil]
Luan Moreno M. MacielData/Cloud Architect and Lead Database Consultant
MCT – Microsoft Certified Trainer
Pythian – Lead Database Consultant
AWS Solutions Architect
Microsoft Azure & Amazon AWS – Cloud Architect
MCSE – Data Management and Analytics
![Page 3: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/3.jpg)
Agenda
Microsoft Azure & Amazon AWS
DataCenter Environment Comparison
SQL Server Deployment Evolution
PaaS - Database Offerings in Microsoft Azure and Amazon AWS
Azure SQL Database Vs. Amazon RDS
![Page 4: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/4.jpg)
Microsoft Azure & Amazon AWS
![Page 5: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/5.jpg)
Microsoft.Azure Vs. Amazon.AWSNews & Cloud Updates
AWS dominates cloud computing infrastructure market, bigger than IBM/Google/Microsoft combined
https://techcrunch.com/2017/02/13/why-aws-has-such-a-big-lead-in-the-cloud/
http://www.zdnet.com/article/aws-dominates-cloud-computing-infrastructure-market-bigger-than-ibmgooglemicrosoft-combined/
https://techcrunch.com/2017/02/13/why-aws-has-such-a-big-lead-in-the-cloud/?ncid=rss&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Techcrunch+%28TechCrunch%29&utm_content=Google+UK
Azure rising: Microsoft will be largest Infrastructure as a Service vendor by 2019, says new Morgan Stanley survey
http://www.geekwire.com/2016/azure-rising-microsoft-will-largest-infrastructure-service-vendor-2019-says-new-morgan-stanley-survey/
Amazon AWS Launch Date = 2006
Microsoft Azure Launch Date = 2010
Amazon cloud has 1 million users and is near $10 billion in annual sales
https://arstechnica.com/information-technology/2016/04/amazon-cloud-has-1-million-users-and-is-near-10-billion-in-annual-sales/
Microsoft celebrates strong Azure adoption at Build 2016
• 120k new customers per month• 1.4 million SQL Databases in Azure• 2 trillion messages per week Azure IoT• 4 million developers registered with VSTS
https://techcrunch.com/2016/03/31/azure-growth/
![Page 6: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/6.jpg)
Microsoft.Azure Vs. Amazon.AWSCloud Pillars Stack
Compute
Storage
Database
Content Delivery
Networking
![Page 7: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/7.jpg)
Microsoft.Azure Vs. Amazon.AWSAWS and Azure Features Differentiation
![Page 8: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/8.jpg)
DataCenter Environment Comparison
![Page 9: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/9.jpg)
Amazon.AWSDataCenter’s Available
42 Availability Zones
16 Geographic Regions
5+ Availability Zones and +2 Regions in 2017/2018
https://aws.amazon.com/about-aws/global-infrastructure/
![Page 10: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/10.jpg)
Microsoft.AzureDataCenter’s Available
Available in 140 Countries
17 Languages and 24 Currencies
https://www.microsoft.com/en-us/cloud-platform/global-datacenters
32 Geographic Regions
+6 Upcoming Regions in 2017/2018
![Page 11: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/11.jpg)
SQL Server Deployment Evolution
![Page 12: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/12.jpg)
IaaS On-Premises PaaS
![Page 13: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/13.jpg)
PaaS - Database Offerings in
Microsoft Azure and Amazon AWS
![Page 14: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/14.jpg)
PaaS – [DBaaS] – Database-as-a-Services
Self-Managed
Reduce Overall Costs *
Reduces Ongoing Administration
Do Not Manage any Virtual Machine
Relational Database Management System
Scalable On-Demand and On-Fly
![Page 15: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/15.jpg)
Amazon.AWS & Microsoft.AzurePaaS - Database Offering
![Page 16: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/16.jpg)
Azure SQL Database Vs. Amazon RDS
![Page 17: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/17.jpg)
General
Recommendations for
Azure & Amazon AWS
![Page 18: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/18.jpg)
Microsoft Azure & Amazon AWSGeneral Recommendations
CbM – Compress Before Migrate
Verify Available Regions
Amazon AWS - https://aws.amazon.com/about-aws/global-infrastructure/Microsoft Azure - https://azure.microsoft.com/en-us/regions/
Ping Test
Amazon AWS - http://www.cloudping.info/Microsoft Azure - http://www.azurespeed.com/
SQL Server Agent
Amazon AWS = Available with Limitationshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html
Microsoft Azure = Azure Automationhttps://blogs.technet.microsoft.com/uktechnet/2016/02/05/is-sql-server-agent-missing-from-azure-sql-database/
![Page 19: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/19.jpg)
![Page 20: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/20.jpg)
Azure SQL DatabaseFinding Appropriate Size
Performance Baseline
Recommended Service Tier – [DTU Calculator]http://dtucalculator.azurewebsites.net/https://docs.microsoft.com/en-us/azure/sql-database/sql-database-benchmark-overviewhttp://blog.tyang.org/2016/07/17/calculating-sql-database-dtu-for-azure-sql-db-using-powershell/
DTU – Database Throughput Unithttps://channel9.msdn.com/Series/Windows-Azure-Storage-SQL-Database-Tutorials/Scott-Klein-Video-02https://docs.microsoft.com/en-us/azure/sql-database/sql-database-what-is-a-dtu
![Page 21: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/21.jpg)
Amazon RDSFinding Appropriate Size
Performance Baseline
SQL Server SE or EE - [DB Instance Class]• SE [Standard] - db.m4.4xlarge – 16 vCPU | 64 GiB RAM• EE [Enterprise] - db.m4.10xlarge – 40 vCPU | 160 GiB RAM
License Model• For SE = License Included & BYOL• For EE = Only BYOL• https://aws.amazon.com/windows/resources/licensing/• http://www.pcworld.com/article/3142340/database/every-version-of-sql-server-2016-now-gets-its-full-feature-set.html
DB Engine Version• SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 | SQL Server 2016 • http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
Time Zone
Storage Type• Magnetic• General Purpose (SSD)• Provisioned IOPS
![Page 22: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/22.jpg)
Demo
Microsoft.Azure Vs. Amazon.AWSPortal Walkthrough and DBaaS Checklist [DTU Calculator]
![Page 23: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/23.jpg)
Performing a Seamless
Migration
![Page 24: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/24.jpg)
Azure SQL DatabaseMigration Methods
Transactional Replication
SSMS – Management Studio
BacPac + Azure Portal/PowerShell/SSMS
SSDT + BCP/SSIS
Azure Data Factory
http://www.nikoport.com/2016/09/18/migrating-to-azure-sqldatabase/
![Page 25: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/25.jpg)
Amazon RDSMigration Methods
Amazon RDS Migration Tool [Decommissioned April/2016]https://aws.amazon.com/blogs/apn/introducing-the-amazon-rds-migration-tool/
SQL Azure Migration Wizard - [SQLAzureMW Tool]http://cloudacademy.com/blog/how-to-migrate-sql-server-database-to-amazon-rds/https://sqlazuremw.codeplex.com/ - Last Version Update – June/2015
Support for Native Backup/Restore Amazon S3 – July/2016https://aws.amazon.com/blogs/aws/amazon-rds-for-sql-server-support-for-native-backuprestore-to-amazon-s3/http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html
AWS Database Migration Service [DMS] – March/2016https://aws.amazon.com/dms/http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.htmlhttps://aws.amazon.com/blogs/aws/aws-database-migration-service/
![Page 26: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/26.jpg)
Implementing
Business Continuity
Plan
![Page 27: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/27.jpg)
Azure SQL DatabaseBusiness Continuity
Active Geo-Replicationhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overviewhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity
Long-Term Backup Retention [Up To 10 Years]https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retentionhttps://azure.microsoft.com/en-us/blog/azure-sql-database-now-supporting-up-to-10-years-of-backup-retention-public-preview/
![Page 28: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/28.jpg)
Amazon RDSBusiness Continuity
Multi-AZ Deploymenthttps://aws.amazon.com/rds/details/multi-az/http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.htmlhttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
Automated Backupshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.htmlhttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html
Database Snapshotshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
![Page 29: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/29.jpg)
Demo
Microsoft.Azure Vs. Amazon.AWSImplementing Business Continuity in Microsoft Azure and Amazon AWS
![Page 30: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/30.jpg)
![Page 31: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/31.jpg)
Azure SQL DatabaseTuning, Monitoring and Optimizing
Watchdog with Alert Rules
Performance• Overview• Recommendation• Query Performance Insight• Automatic Tuning
Dynamically Scale-Up & Down using Azure Automation
Index Maintenance Operation using Azure Automation
![Page 32: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/32.jpg)
Amazon RDSTuning, Monitoring and Optimizing
Watchdog with CloudWatch• https://aws.amazon.com/cloudwatch/• http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Monitoring.html#USER_Monitoring• Fee Tier = 5 Minutes• Detailed = 60 Seconds
Dynamically Scale-Up & Down Based on Workload https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/
Use SNS [Simple Notification Service] for Event Notification• http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html
![Page 33: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/33.jpg)
Demo
Microsoft.Azure Vs. Amazon.AWSShowing Features in Azure and AWS Portal
![Page 34: SQL Server Konferenz 2017 Azure vs. Amazon RDS.pdf · MVP –Data Platform [+4 Years | Based in Brazil] Luan Moreno M. Maciel Data/Cloud Architect and Lead Database Consultant MCT](https://reader034.vdocuments.us/reader034/viewer/2022050106/5f444e6cef73631fc22c66f7/html5/thumbnails/34.jpg)
Thank You!Danke!
@luansql