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.com/Migration


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

5 views

Recent Posts

See All

ENABLING SMBS WITH TECHNOLOGY

Section 1: Market Overview Key Points Small and medium businesses (SMBs), typically defined as having fewer than 500 employees, are a major part of the U.S. economy. These firms represent 99.7% of the