1 / 15

End of support Cloud P athways for SQL Server 2008/R2 Customers

End of support Cloud P athways for SQL Server 2008/R2 Customers. September 2018. Impact of end of support. Deadline to act before end of support. No security updates. Extended Support ends July 9, 2019. SQL Server 2008 and 2008 R2. Compliance concerns. Extended Support

cmccoy
Télécharger la présentation

End of support Cloud P athways for SQL Server 2008/R2 Customers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. End of supportCloud Pathways for SQL Server 2008/R2 Customers September 2018

  2. Impact of end of support Deadline to act before end of support No security updates Extended Support ends July 9, 2019 SQL Server 2008 and 2008 R2 Compliance concerns Extended Support ends January 14, 2020 Windows Server 2008 and 2008 R2 Missed innovation opportunities 2018 2019 2020 Find lifecycle support deadlines at: support.microsoft.com/lifecycle

  3. Saving opportunity for modernizing your data estate is significant Infrastructure (as a Service) Traditional on-premises Platform (as a Service) On-premise coststends to be driven by heavy hardware investment and data center management costs Lower maintenance and management with Azure because certain cost categories (such as data center cost, compute cost) will likely decrease or go away Applications You manage MSFT manages MSFT manages MSFT manages Applications Applications Applications Database Database Database Database Azure SQL Database (Managed Instance) SQL Server 2017 Azure SQL VMs Azure SQL Database (Singleton/Elastic Pools) Server Instances Server Instances Server Instances Server Instances Platform-as-a-Service, can off-load the most administrative burdens to Azure which manages the platform at scale. Also, Azure’s tiered approach in PaaS fully enables customer choice OS OS OS OS HW/Data center HW/Data center HW/Data center HW/Data center Managed by MSFT Managed by customer

  4. Azure SQL Database Managed Instance: the best pathway for end of support customers Focus of Discussion Lift-and-shift to PaaS with Azure SQL Database Managed Instance (MI) • SQL DB MI takes source version as far back as SQL Server 2005; no more future upgrades required as SQL DB will always run on the latest feature as part of fully managed services Modernize to Azure SQL Server 2008/R2 end of support Move to IaaS with Azure SQL VM Upgrade to SQL Server 2017 on Azure VMs, or Move “as-is” with SQL Server and Windows Server 2008/R2 and get 3 years of Extended Security Updates* for free Modernize on premises SQL Upgrade on premises Upgrade to SQL Server 2017** (and Windows Server 2016) * ESU worth 75% of license every year for the next three years after EOS

  5. Azure SQL Database Managed Instance: Best for modernization at scale with low cost and effort SQL * SQL Database (including MI) uses database compatibility level to decouple the application from specific versions of SQL Server, thus enabling applications running on older versions of SQL Server to run on the latest DB engine. Read more on the FAQ of Database Compatibility

  6. Three financial options for modernizing to Azure SQL Server and Windows Server 2008/R2 Modernize to Azure Recommended Option A Use Software Assurance for Azure Hybrid Benefits (AHB) • Use on-premise cores for vCores in Azure; • Up to 4 vCores per 1 Enterprise Edition core • Dual use rights up to 180 days • One-click experience enabling AHB in billing • Option B Server subscription for CSP customers • SQL Software Subscriptions give customers the same benefits as Software Assurance • All Option A benefits would apply • Flexibility to try out Azure SQL without heavy upfront commitment Option C License included cost (pay-as-you-go under PaaS) • Pay for what you use • Azure IaaS customers (without SA) running on SQL Server 2008/R2 will qualify for free ESU

  7. Azure SQL Database Managed Instance: the best option to run SQL workloads Save up to 59% compared to RDS Best TCO SQL parity Full parity based on 100% code consistency SQL support 99.99% SLA, supporting source version back to SQL 2005 SQL PaaS ++ Machine-Learning based performance and security on top of PaaS

  8. SQL Database Managed Instance offers the best financial value $10.0/Hr Pricing comparisons on 8 core SQL Server EE & SE (MI w/AHB* vs AWS RDS) SQL DB MI 1: 4 vCore SQL DB MI 1: 1vCore Cost on SQL DB = $4.88 Best TCO $5.44/Hr 46% SQL parity 4 sets 8 vCore at Base rate w/ SA, each = $1.22 $3.02/Hr SQL support Cost on AWS RDS = $12.08 33% $2.02/Hr SQL PaaS ++ 4 sets 8 vCore at License Included, each = $3.02 Azure SQL Database Business Critical AWS RDS SE Single-AZ (List) Azure SQL Database General Purpose AWS RDS EE Multi-AZ (List) 59% RDS customers running SQL Server 2008/R2 will not have access to Extended Security Updates and will be out of compliance Note: On-Demand Prices for a D13 v2 VM. Pricing accessed on December 2017. US East 2. Comparable AWS VM is r3.2xlarge. AWS Prices based on US East (Virginia). Savings analysis assumes that customer is paying software assurance on SQL Server. Does not include SA for Windows Server as those costs are fairly negligible - $164 per 2-core license for WS DC, and $23 for Standard (OLP, NL).

  9. SQL Database Managed Instance is a turn-key solution for SQL Server in the cloud AWS RDS Azure SQL Database Managed Instance • Limited surface area** • No Linked Server, Transactional replication, SQL Server Audit, DB Mail, server level triggers, sysadmin permissions​ • Do not support Always-On for high availability • Backup PITR only at instance level vs. SQL DB goes into DB level • Do not support R/Python integration for machine-learning Full surface area, just like your on-prem SQL Server* On highest version while backward compatible, given everything is being engineered from the Cloud Lift and shift from on-prem with no application code change and minimum database changes* DMS migration tool enable minimum down-time, massive scale migration Best TCO SQL parity SQL support SQL PaaS ++ • Pegged to specific versions as in on premises SQL Server *Note: SSIS is available in PaaS under Azure Data Factory V2; SSAS can be ported to AAS as PaaS; SSRS can stay on Azure VM as IaaS **See list of non-supported features on RDS

  10. SQL Database Managed Instance provides unmatched support AWS RDS Azure SQL Database Managed Instance Support migration source back to SQL Server 2005 (via Backups) Limited migration source and support Best TCO SQL parity • Database Compatibility Level 100 and higher supported • Migration source back to SQL Server 2008​ SQL support • No more version upgrades as it runs on highest version and everything is being managed by Microsoft* • Will still face End of Support and upgrade needs SQL PaaS ++ • SLA at 99.95% only with Multi-AZ deployment • SLA at 99.99% for any services out of the box * See SQL Database Compatibility Level FAQ for details on how Azure SQL DB, including MI, is able to decouple from versions of on premises SQL Server and maintain application as-is.

  11. SQL Database Managed Instance brings ML-based performance & security AWS RDS Azure SQL Database Managed Instance Intelligent Advisor and ML-based, Intelligent Insights and recommendation based on root-cause analysis; Auto-tuning from massive DB insights and tailored to specific DB query Built-in HA with Always-on; active-active GEO replication, providing you the 99.99% SLA out of the box Table Stake, light-wrapper PaaS only: No ​Advisor for RDS for SQL Server such as performance insights & recommendation*. • No built-in Always On for HA, customer needs to purchase Multi-AZ (2nd VM) to get the 99.95% SLA Best TCO SQL parity SQL support SQL PaaS ++ • Advanced Threat Protection (ATP) enables data discovery & classification, vulnerability assessment, and advanced threat detection No ATP such as Threat Detection, Vulnerability Assessment, Information Classification *Note: AWS Performance insights only available to Aurora and RDS PostgreSQL,/MySQL based on historical query snapshot only.

  12. Azure SQL VM: free extended security updates for end of support customers Save 5x compared to AWS EC2 ** Best TCO Configuration Pre-configurated Developer edition, configurable cloud backup Support Free extended support for SQL Server 2008/R2* Security Ease of maintenance with automatic application of security patches * ESU worth 75% of license every year for the next three years after EOS

  13. SQL VM on Azure offers great financial value Pricing comparison (on-prem, SQL VM w/AHUB on Reserved Instance, AWS EC2* w/ paid ESU on Reserved Instance) Best TCO Configuration Support Security • AWS EC2 does allow licensing mobility for customers to save on SQL IP. • Note: Price comparison dated 09/10/2018 based on: Standard 3-Year Reserved Instance EC2 pricing on 8-core M4.2xlarge on US West (North California) vs. Azure SQL Dv8 VM on US west

  14. Start your migration journey today Assess Inventory your environment, determine optimal migration path Migrate Move your legacy SQL Server to Azure or upgrade to the latest version Optimize Fine-tune your resources to optimize costs and strengthen security Get detailed guidance with the Database Migration Guide Find a Migration Partner Visit the Microsoft Data Migration Blog Inventory your environment with MAP Toolkit Innovate faster with SQL Server 2017 Lift and shift your SQL Server to Azure SQL Database • Learn more about SQL Server on Azure Virtual Machines Compare costs with the TCO calculator Save with Azure Hybrid Benefit Learn about SQL Server and GDPR Manage costs in Azure

  15. Thank you

More Related