Server SQL
IT OPTIMIZATION IS KEY TO DIGITAL TRANSFORMATION IDC Worldwide Database Server Forecast
SQL Server
37% of all units run Microsoft, >50% of units run 2008/R2 or older2
Priorities
• Eliminate time spent managing “long tail” of applications—lift and shift to managed cloud
• Free up limited IT resources to drive transformation
• Migrate business critical apps to cloud—extend and innovate
1 Pie Chart *IDC Worldwide DB Forecast Dec 2016 2 Microsoft Internal Sources
AZURE SQL DATABASE
THE BEST AND MOST ECONOMICAL CLOUD DESTINATION FOR YOUR SQL SERVER APPS
Built-in intelligence Breakthrough productivity Seamless and compatible Competitive TCO and performance
Realize up to a 212% ROI over on-premises and hosted solutions
4.5 million databases
3 trillion batch requests/day
154 PB total size
1.4 million HTAP transactions/sec
421K subscriptions
100 million queries analyzed/hour
AZURE SQL DATABASE MOMENTUM
“We had an incident lasting for about 6 months. Before Intelligent Insights we have not had a way of figuring out where do we even start troubleshooting. Intelligent Insights gave us a list of things to do...it enables us to pinpoint where the problem is and to get a fix deployed within 24hrs.”
Frans Lytzen – CTO, New Orbit
“Intelligent Insights proactively finds a database performance problem in a more efficient way and much faster than humans. With it we can proactively help customers until we have a fix for the problem.”
Bauke Stil, App Manager, SnelStart
“SQL Threat Detection helps us to be ahead of the threats instead of chasing them.”
Shahin Kohan, CTO
“SQL Threat Detection helps us respond to activities, which were not visible beforehand.”
Manrique Logan, architect & technical lead
AZURE SQL DATABASE RESOURCE TYPES
Single
Database-scoped deployment option with predictable workload performance
Best for
apps that require resource guarantee at database level
SQL
Azure SQL Database Elastic Pool
Shared resource model optimized for greater efficiency of multi-tenant applications
Best for
SaaS apps with multiple databases that can share resources at database level, achieving better cost efficiency
Managed Instance
Instance-scoped deployment option with high compatibility with SQL Server and full PaaS benefits
Best for
modernization at scale with low friction and effort
BUILT-IN INTELLIGENCE TO PROTECT AND OPTIMIZE
Intelligent Performance learns unique database patterns and automatically tunes for improved performance
Intelligent Protection powers advanced data security features that monitor, detect, and alert on malicious activities and discover, track and remediate potential database vulnerabilities
Tuning algorithms
SQL
SQL Database
“My app gets auto-tuned”
Developer no admin skills
Database advisor
“I can do more in less time”
DBA of many databases
CONTINUOUSLY OPTIMIZED BY THE PLATFORM
• One-click to enable
• Prevent and mitigate issues
• No app changes needed
• Tuning actions
• Create missing indexes
• Drop unused/duplicate indexes
• Force last good plan
Automatic tuning
PUT YOUR DATABASE ON AUTO-PILOT AND FOCUS ON YOUR BUSINESS
Your work so far
How SQL Database helps
Hardware purchasing and management
Built-in scale on-demand
Protect data with backups (with health checks and retention)
Built-in point-in-time restore
High availability implementation
Built-in 99.99% SLA and auto-failover
Disaster recovery implementation
Built-in geo-redundancy and geo-replication
Ensure compliance with standards on your own
Built-in easy to use features
Secure your data from malicious users and mistakes
Built-in easy to use features
Role out updates and upgrades
Built-in updates and upgrades
Monitor, troubleshoot, and manage at scale
Built-in easy to use features
Tune and maintain for predictable performance
Built-in easy to use features
We take care of your database chores
BREAKTHROUGH PRODUCTIVITY AND PERFORMANCE
Realize the benefits of real-time operational analytics
Enable scale-up with near zero downtime through cloud-born innovation
Classified as Microsoft Confidential
30x
faster transactions with in-memory OLTP
100x
performance gains with in-memory analytics
near 100% uptime with dynamic scalability
SAVE TIME WITH FAMILIAR SQL SERVER TOOLS AND RESOURCES
Combine the best of SQL Server with the benefits of a fully-managed service
Use familiar SQL Server features in SQL Database Managed Instance
Native backup and restore
Cross-database queries and transactions
Broad security features including Transparent Data Encryption, SQL Audit, Always Encrypted and Dynamic Data Masking
SQL Agent, DBMail, and Alerts for workload orchestration improved awareness
Scenario enablers including Change Data Capture, Service Broker, Transactional Replication, and CLR
DMVs, XEvents, and Query Store for troubleshooting
Full compatibility with SQL Server 2005+
DEDICATED RESOURCES THROUGH CUSTOMER ISOLATION
Enable full isolation from other tenants without resource sharing
Promote secure communication over private IP addresses with native VNET integration
Enable your on-premise identities on cloud instances, through integration with Azure Active Directory and AD Connect
VNET support in SQL Database Managed Instance
COMPETITIVE TOTAL COST OF OWNERSHIP
Reduce capital and operational costs with a fully- managed service and achieve up to 406% ROI1
Financially-backed 99.99% availability SLA2
Promote business continuity with built-in capabilities
Maximize your on-premises investments with Azure Hybrid Benefit for SQL Server and reserved capacity pricing
Right-size on-premises workload requirements for the cloud with independent control of storage and compute
Up to 212% ROI with Azure SQL Database
$3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000
$500,000 $0
($500,000)
Financial Analysis (risk-adjusted)
1234 Series1 Series2 Series3
Source: The Total Economic ImpactTM of Microsoft Azure SQL Database Managed Instance, Forrester Consulting, September 2018
Cash flows
DTUS SIMPLIFY CERTAIN ELEMENTS FOR CUSTOMERS BUT CAN MAKE ON- PREMISES TRANSITIONS DIFFICULT
Challenges with translating on-premises workload requirements to the cloud when migrating
More flexibility desired to optimize resources for SQL Database workloads
Classified as Microsoft Confidential
RIGHT-SIZE YOUR WORKLOADS FOR THE CLOUD
Easier to right-size the destination environment by removing the guesswork of DTUs
You pay only for what you use
1 on-premises core = 1 vCore on Gen4 hardware
Classified as Microsoft Confidential
Introducing vCores
SELECTING THE RIGHT PURCHASING OPTION
Flexibility
vCore-based
Independently configure compute, storage, IO
Most economical with Azure Hybrid Benefit for SQL Server
Simplicity
DTU-based
Blended measure of compute, storage, IO
May be more economical for < 3 cores
• Compare vCore-based and DTU-based options using this rule of thumb: 100DTU ~ 1 vCore
• Convert from DTU to vCore using the API or portal with no downtime and same SLO update as today
COMMITTED TO CUSTOMER CHOICE
Choice drives our approach to resource management and pricing
• Simplicity: We remain committed to the DTU-based model and the simplicity it offers customers who want a pre-configured solution
• Flexibility: The vCore-based model reflects our commitment to customer choice and to simplify the hybrid benefit for customers migrating from on-premises
Customers pay for:
• Service tier + number of vCores
• Type and amount of data storage
• Number of IO*
• Backup storage (RA-GRS)*
The vCore-based model will exist alongside the DTU-based model
Learn more
*Free during preview
**4TB available on Gen 5 only
***Coming soon
Best for
Compute tiers
Storage
Availability
Backups
GENERAL PURPOSE
Most business workloads. Offers budget oriented balanced compute and storage options.
Premium remote storage (per instance)
Single/Elastic Pools
1 replica, no read-scale
RA-GRS, 7-35 days (7 days by default)
Managed Instance
32GB – 8TB
HYPERSCALE
Data applications with large data capacity requirements and the ability to auto-scale storage and scale compute fluidly.
Two hardware generations to choose from
De-coupled storage with local SSD cache (per instance)
Single database
Up to 100TB
Configurable replicas, up to 15 read-scale
RA-GRS, 7-35 days (7 days by default), constant time PITR
BUSINESS CRITICAL
OLTP applications with high transaction rate and low latency IO. Offers highest resilience to failures using several isolated AlwaysON replicas
Single/Elastic Pools
1 to 80 vCores
Managed Instance
8, 16, 24, 32, 40, 64, 80 vCores
Single database
1 to 80 vCores
Single/Elastic Pools
1 to 80 vCores
Super-fast local SSD storage (per instance)
Managed Instance
8, 16, 24, 32, 40, 64, 80 vCores
Single/Elastic Pools
5GB – 4TB
3 replicas, 1 read-scale, zone- redundant HA***
RA-GRS, 7-35 days (7 days by default)
Managed Instance
5GB – 4TB
32GB – 4TB**
Choose from three tiers in the vCore-based model
AZURE IS THE MOST ECONOMICAL DESTINATION FOR SQL WORKLOADS*
Use your on-premises SQL Server licenses with active Software Assurance to save up to 55% on vCore-based SQL Database deployment options with Azure Hybrid Benefit for SQL Server
Pre-pay your SQL Database compute capacity on a one or three-year term and save up to 33% with SQL Database reserved capacity
Combine the Azure Hybrid Benefit for SQL Server and SQL Database reserved capacity for even more savings, up to 80%.
Learn more:
• Azure Hybrid Benefit
• Azure SQL Database reserved capacity
*Based upon comparison of on-demand pricing on Azure for
Managed Instance versus running SQL on AWS RDS.
Classified as Microsoft Confidential
Save up to 80% with Azure Hybrid Benefit for SQL Server and SQL Database reserved capacity
Total monthly cost of 8 vCore Managed Instance Business Critical option
Up to 55% savings1
Up to 80% savings2
Customer total cost
License included
With Azure Hybrid Benefit
Reserved capacity with Azure Hybrid Benefit
1 Savings based on eight vCore Managed Instance Business Critical in East US Region, running 730 hours per month. Savings are calculated from full price (license included) against base rate (applying Azure Hybrid Benefit for SQL Server), which excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.
2 Savings based on eight vCore SQL Database Managed Instance Business Critical in West 2 US Region, running 730 hours per month. Savings are calculated from on demand full price (license included) against base rate with Azure Hybrid Benefit plus 3-year reserved capacity commitment. Savings excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.
EXCLUSIVE TO AZURE: GET MORE FOR YOUR VIRTUALIZED WORKLOADS
Take an inventory of on-premises licenses to determine potential for conversion
Convert on-premises cores to vCores to maximize value of investments
1 Standard license core = 1 General Purpose core
1 Enterprise license core = 1 Business Critical core
1 Enterprise license core = 4 General Purpose cores (virtualization benefit)
Classified as Microsoft Confidential
SQL Server license trade-in values SQL Database Managed Instance
Business Critical
General Purpose
Standard Edition
General Purpose
Highly virtualized, Enterprise Edition
Enterprise Edition
SQL Server with Software Assurance
OR
Tools for your migration journey
SQL Server Migration Assistant (SSMA)
Automates database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.
Data Migration Assistant (DMA)
Enables upgrade to SQL Server and Azure SQL Database.
Database Experimentation Assistant (DEA)
Assists in evaluating a targeted version of SQL for a given workload.
Azure Hybrid Benefit for SQL Server
Maximizes current on-premises license investments to facilitate migration.
Azure SQL Database Managed Instance
Facilitates lift and shift migration from on-premises SQL Server to PaaS.
SQL Database Managed Instance
Azure Database Migration Service (Azure DMS) SQL Server Migration Assistant (SSMA)
Data Migration Assistant (DMA)
Database Experimentation Assistant (DEA)
Azure Hybrid Benefit for SQL Server
ACCELERATING YOUR JOURNEY TO THE CLOUD
Fully managed database migration service for both operational databases and data warehouses
Enables reliable and seamless migrations to the cloud at scale and minimal downtime
Migrate SQL Server & 3rd party databases to Azure SQL Database
Classified as Microsoft Confidential
Azure Database Migration Service
SQL
MySQL SQL
SQL Server
Azure SQL Database single, elastic pools and Managed Instance
MySQL
Azure Database for MySQL
PostgreSQL
Azure Database for PostgreSQL
Oracle, ...
Azure SQL Database & Managed Instance
Netezza, ...
Azure SQL Data Warehouse
YOUR SINGLE DESTINATION FOR ALL THINGS MIGRATION
Provides guidance, tools, and partners in context of your migration scenario
Enables you to:
• Build your case, find others like you
• Assess your environment
• Identify the right migration strategies
• Optimize your cloud resources
Connects you to a migration expert
• Chat enabled, backed by engineering resources
• Guides you to FastTrack, partner, seller, or DIY outcomes
Azure migration center
MIGRATION COOKBOOK
Migrate an on-premises SQL Server database to Azure SQL Database
The Migration Cookbook describes various approaches you can use to migrate an on-premises SQL Server database to the latest Azure SQL Database Update
Download: https://azure.microsoft.c om/en-us/resources/choosing- your-database-migration-path-to- azure/en-us/
Classified as Microsoft Confidential
LEARN MORE
Classified as Microsoft Confidential
• Azure SQL Database
• SQL Database Managed Instance
• Create a Managed Instance
• Forrester Consulting Total Economic ImpactTM study
• Azure Hybrid Benefit for SQL Server
• Azure Database Migration Service
• Migration Guide
• SQL Server Integration Services
• Hands-on-lab to lift SSIS to Azure with Azure Data Factory: aka.ms/adflab
CHOOSE FROM TWO HARDWARE GENERATIONS
• Balance performance requirements and price with two hardware generations
• Match your on-premise application behavior
Classified as Microsoft Confidential
Hardware
Performance levels
Memory
Storage
7GB per vCore
Gen 4
Intel E5-2673 v3 (Haswell) 2.4 GHz processors
vCore = 1 PP (physical core)
1, 2, 4, 8, 16, 22 vCores
Up to 4TB premium remote storage Up to 1TB local SSD storage
Gen 5
Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, fast eNVM SSD
vCore=1 LP (hyper-thread)
2, 4, 8, 16, 24, 32, 48, 72 vCores
5.5GB per vCore
Up to 4TB premium remote storage Up to 4TB local SSD storage
BUSINESS INTELLIGENCE SERVICES
Not installed side-by-side with Managed Instance
Migrate your SSIS packages to new SSIS on Azure Data Factory (PaaS service)
Migrate your OLAP models to Azure Analysis Services
... or run these services in Azure virtual machines
For SSRS: run in a virtual machine, or switch to Power BI
Classified as Microsoft Confidential
Recommendation - move BI solutions to PaaS model
PowerBI
SSIS / SSAS PaaS
SSIS / SSAS
APPLYING AZURE HYBRID BENEFIT
Managed Instance is available in 8, 16, 24, 32 and 40 vCore instances
The number of instances eligible for Azure Hybrid Benefit is calculated based upon
• number and type of licenses you are exchanging
• Managed Instance vCore selection, rounding down to the nearest whole value.
Classified as Microsoft Confidential
How to calculate instances eligible for the hybrid benefit
Calculation = (10 Standard license cores * 1 core) + (10 Enterprise license cores * 4 cores) = 50 cores
Eligible number of instances:
(50 cores / 8 vCore instance) = 6 eligible instances
Calculation = (5 Standard license cores * 1 core) + (20 Enterprise license cores * 4 cores) = 85 cores
Eligible number of instances:
(85 cores / 16 vCore instance) = 5 eligible instances
1 Standard license core = 1 General Purpose core
1 Enterprise license core = 4 General Purpose cores (virtualization benefit)
WHAT IS VIRTUALIZATION?
License all physical cores in the server
6 6
Deploy VMs equal to number of core licenses
VM SQL Server
HIGH-VIRTUALIZATION BENEFIT FOR AHB FOR SQL SERVER
For virtualized EE workloads, customers get 4X vCore on Azure SQL DB vs. 1X core on Azure IaaS
SQL Database Managed Instance
SQL DB will be ~22%
cheaper than Azure IaaS
Hosted/VM
8 vCore at Base rate w/ SA
8 vCore at Base rate w/ SA
8 vCore at Base rate w/ SA
8 vCore at Base rate w/ SA
$1.55
$1.55
$1.55
Enterprise Edition Customer Highly Virtualized
e.g. 32 core virtualized workload with 8 core SQL EE License
8 core at BYOL w/ SA
8 core at License Included
8 core at License Included
8 core at License Included
*All the SKUs above are 8 vCPU or vCore memory optimized equivalent. (D13v2 for Azure IaaS). The SA cost are based Open NL EE for SA. The License included prices are 8 core D13v2 for Azure IaaS. US East price. ** Prices as on Oct 2 2017
Classified as Microsoft Confidential
Cost on SQL DB (MI)= $6.21
AHB for SQL Server with Managed Instance
License Mobility for Azure IaaS Standard SE
$1.55
Cost on Azure IaaS= $7.92
$1.85
$1.85
$1.85
$2.39