What is SQL Database Managed Instance? SQL Database (DBaaS) A - - PowerPoint PPT Presentation

Unmatched app compatibility

• Fully-fledged SQL

instance with nearly 100% compat with

• n-prem

Unmatched PaaS capabilities

• Lowest TCO + rich

Azure ecosystem

• Learns and adapts

with customer app

Favorable business model

• Competitive
• Transparent
• Frictionless

A flavor of SQL DB that designed to provide easy app migration to a fully managed PaaS

SQL Database (DBaaS) Elastic Pool Managed Instance Single DB

What is SQL Database Managed Instance?

Easy migration: nearly 100% like SQL Server

Note: features will be added in stages until General Availability of Managed Instance Security

• TDE
• SQL Audit
• Row level security
• Always Encrypted

What’s is missing?

• Features that are obsolete in the cloud (or have a better alternative)

Always-On Availability Groups: HA is built-in Windows Authentication: Azure Active Directory is the alternative. Management Data Warehouse : OMS integration is the alternative. Policy Based Management: common DBA tasks are performed by SQL Database.

• Features that have been retired

Database Mirroring: built-in HA / geo-replication are better alternatives Extended stored procedures: customers should use CLR

• Features that are considered post-GA

Filestream Filetable Cross-instance distributed transactions (and other transactions types that require MS DTC) Master Data Services (MDS) Data Quality Services (DQS) Stretch Database

A Full-blown PaaS Offering

Managed instance is a flavor of SQL DB that inherits the PaaS features

• Provisioning and resizing (w/ Azure Portal experience)
• Built-in auto HA (99.99% availability)
• Business continuity: automatic and user-initiated

backup, PITR, Geo-DR

• Adheres to compliance standards same as SQL DB
• Security: TDE, AAD authentication
• Automatic patching / version update
• Intelligent Database features
• Database Advisor (automatic tuning, insights @ scale)
• Threat Detection
• E2E integration with other PaaS data services (SSIS,

SSAS)

Managed Instance: new business model

• Choose compute resources and storage independently, from two service tiers
• Azure Hybrid Use Benefit: use your on-premise licenses, with software assurance, to get discounts

Service tier General Purpose (high SLA, fast storage) Business Critical (very high SLA, super fast storage) Instance compute resources (contains multiple databases) 8, 16, and 24 vCores Charged per: vCore / hour 8, 16, and 24 vCores Charged per: vCore / hour Type of storage (reserved in multiplies of 32 GB) Fast remote (up to 35 TB) Charged per: GB / hour Super fast local SSD (up to 4 TB) Charged per: GB / hour Backup storage 7 days retention free of charge Charged per GB / hour 7 days retention free of charge Charged per: GB / hour I/O operations Charged per million IOs Charged per million IOs

Managed Instance connectivity

SQL Instance #1 SQL Instance #2 IPsec IKE S2S VPN Tunnel оn-premises VPN / Express Route Gateway SQL Instance #3 VNet1 VNet-to-VNet Network isolation (customer VNET) Tenant isolation (compute, storage)

“Virtual data cluster” dedicated to customer (virtual private cluster, VNET, private IPs)

Web app (public IP)

2017

Managed Instance roadmap

Surface area++, classic VNET, AAD, SSIS PaaS Portal, PITR, DMS min. downtime, SQL Audit,

• Tran. Repl., Service

Broker… ARM VNET, REST API, local storage*, DMS SQL Agent, CDC

+ over 130 customers and growing