What is SQL Database Managed Instance? SQL Database (DBaaS) A flavor of SQL DB that designed to provide easy app migration to a fully managed PaaS Managed Elastic Single DB Instance Pool Unmatched app Unmatched PaaS Favorable business compatibility capabilities model • Fully-fledged SQL • Lowest TCO + rich • Competitive instance with nearly Azure ecosystem • Transparent 100% compat with • Learns and adapts • Frictionless on-prem with customer app
Easy migration: nearly 100% like SQL Server Security • • TDE Row level security • • SQL Audit Always Encrypted Note: features will be added in stages until General Availability of Managed Instance
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 Business Critical (high SLA, fast storage) (very high SLA, super fast storage) Instance compute resources 8, 16, and 24 vCores 8, 16, and 24 vCores (contains multiple databases) Charged per: vCore / hour Charged per: vCore / hour Type of storage Fast remote (up to 35 TB) Super fast local SSD (up to 4 TB) (reserved in multiplies of 32 GB) Charged per: GB / hour Charged per: GB / hour Backup storage 7 days retention free of charge 7 days retention free of charge Charged per GB / hour Charged per: GB / hour I/O operations Charged per million IOs Charged per million IOs
Managed Instance connectivity Web app ( public IP ) VNet-to-VNet VNet1 SQL Instance #1 SQL Instance #2 Network isolation (customer VNET) Tenant isolation SQL Instance #3 (compute, storage) “ Virtual data cluster ” dedicated to customer ( virtual private cluster, VNET, private IPs ) VPN / Express Route IPsec IKE S2S VPN Tunnel о n-premises Gateway
Managed Instance roadmap ARM VNET, REST Portal, PITR, DMS min. Surface area++, API, local downtime, SQL Audit, classic VNET, AAD, storage*, DMS Tran. Repl., Service SSIS PaaS Broker… SQL Agent, CDC 2017 + over 130 customers and growing
Recommend
More recommend
