Compete Guide: Oracle ATP vs.
Microsoft Azure SQL DB
Keith Hoang
Oracle Market & Competitive Intelligence
Last Updated: January 2019
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Oracle Market & Competitive Intelligence
For InternalCopyright
Use Only|© 2019Oracle Confidential
Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only
Oracle Confidential. For Internal Use Only.
Do Not Distribute to Third Parties.
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
This analysis/document is provided for information purposes only, and the contents hereof are subject to change
without notice.
This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether
expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a
particular purpose. Estimations shown here can be inaccurate or subject to changes.
Oracle specifically disclaims any liability with respect to this document, and no contractual obligations are formed
either directly or indirectly by this document. Reference herein to third party content, including analysis, opinions,
predictions and statements, does not constitute or imply Oracle’s endorsement of or concurrence with such
content.
Information contained herein is confidential. It is for internal use only and cannot be shared with third parties.
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 2
Agenda
1 Oracle ATP Overview
2 Oracle ATP vs. Microsoft Azure SQL Comparison
3 Customer Case Studies
4 Analyst Perspective
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 3
Oracle ATP Overview
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 4
Autonomous Database
• Traditionally each database deployment was unique
– You are the DB builder, securer, repairer, tuner, and driver
– Complex, labor intensive, poor economies-of-scale
• Autonomous Database revolutionizes data management
– The full database management lifecycle is completely automated
– Even for ultra-mission critical databases with sensitive data
– Enables you to innovate more, pay less, and ensure data safety
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 5
Journey to Autonomous Database
Oracle has invested thousands of engineer years
automating and optimizing database
• Autonomous Health Framework
• Automatic Diagnostic Framework
18c
• Automatic Refresh of Clones
• Automatic Columnar Flash
• Automatic IM population
•
•
Automatic Memory Management
Automatic Segment Space Mgmt
12c • Automatic Application
• Continuity
Automatic Statistics Gathering
• Automatic Storage Management
•
•
Automatic Workload Repository
Automatic Diagnostic Monitor 11g
• Automatic Query Rewrite • Automatic SQL Tuning
• Automatic Undo Management • Automatic Workload Capture/Replay
10g • Automatic SQL Plan Management
9i •
•
Automatic Capture of SQL Monitor
Automatic Data Optimization
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 6
Journey to Autonomous Database (cont.)
And thousands of engineer years
automating and optimizing database infrastructure • Exadata Cloud Service
• In-Memory Columnar in Flash 2018
• Smart Fusion Block Transfer
• Direct-to-wire Protocol
• JSON and XML offload
• Instant failure detection
• Network Resource Mgmt
• Prioritized File Recovery
• IO Priorities
• Data Mining Offload
• Offload Decryption
• Database Aware Flash Cache
• Storage Indexes
• Smart Scan • Hybrid Columnar Data
• Infiniband Scale-Out
2008
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 7
Autonomous Completes the Journey
Brings Full Automation to Entire Database Lifecycle
ORACLE Oracle
AUTONOMOUS Cloud
DATABASE
Complete Complete Automated
Infrastructure Database Data Center Operations
Automation Automation and Machine Learning
World’s First Autonomous Database
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 8
Oracle Autonomous Database Attributes
Self-Driving Self-Securing Self-Repairing
Automates database and Protects from both external Protects from all
infrastructure management, attacks and malicious downtime including
monitoring, tuning internal users planned maintenance
Save on Human Labor Prevent Human Error No Human Intervention
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 9
Full Database Lifecycle is Automated
Provisioning Security Management
Rapidly creates scalable Protects from external and Automates all infrastructure
mission critical databases internal threats and database management
Creates Exadata+ Monitors threats, applies Performs all OS and SYSDBA
Cloud Infrastructure, security updates online+, operations, tunes settings,
RAC+ scale-out database, stops admin snooping with patches all software online+,
Active Data Guard+ standby DB Vault+, encrypts all data diagnoses errors+
+
Unique to Oracle
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 10
Full Database Lifecycle is Automated (cont.)
1 2 3 4 5
Protection Scaling Optimization
Recovers from any failure Scales online for highest Machine Learning optimizes
without downtime performance and lowest cost database for each workload
Automates backup, restore, Instant online elasticity+ Continuously optimizes
application transparent+ of serverless memory, data formats,
failover in scale-out cluster+ compute and storage indexes+, parallelism+, and
or to active remote standby+ enables true pay-per-use+ plans+ for each workload
+
Unique to Oracle
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 11
Oracle ATP vs. Microsoft SQL Azure
Comparison
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 12
Oracle ATP vs. Microsoft Azure SQL Database
Summary
• ATP is built on Exadata, an optimized DB infrastructure for Oracle Database; Microsoft
does not have a similar optimized DB infrastructure to run Azure SQL Database
• ATP is compatible with Exadata Cloud at Customer, while Azure SQL DB is not 100%
compatible with SQL Server, and Azure Stack runs only SQL Server and not Azure SQL DB
• ATP provides complete tenant isolation across the full stack, while Azure SQL DB Logical
Server is shared tenancy
• ATP includes more security features and can automate update of software security fixes
• ATP guarantees 99.995% uptime including maintenance, while Azure SQL DB is 99.99%
• ATP can scale 3X vCPU and 32X DB size compared to the currently available Azure SQL DB
• ATP’s ML-driven automation cuts administration cost by up to 80%
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 13
Oracle ATP vs. Microsoft Azure SQL Database
Compatibility of Database in Cloud and On-Premises
Oracle ATP Microsoft Azure SQL Database
• Same database technology in the cloud and on- • Azure SQL Database is not 100% compatible with
premises on-premises SQL Server
• Autonomous Database on Exadata Cloud at • Many SQL Server features are not supported in
Customer Azure Database, see here
– Autonomous database in customer data center
• Microsoft Azure Stack runs SQL Server and not
– Same cloud hardware, software, interfaces, APIs Azure SQL Database; is a multi-vendor disjointed
– Same pay-per-use subscription model solution; and is inconsistent with Azure Cloud
• Leverage existing licenses, tools, skill sets to easily
transform on-premises operations to cloud based
services
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/using-oracle-autonomous-transaction-processing.pdf
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 14
Oracle ATP vs. Microsoft Azure SQL Database
Tenant Isolation
Oracle ATP Microsoft Azure SQL Database
• Complete stack tenancy isolation • Azure SQL Database Logical Server is shared
– Compute, Storage, Cluster Interconnect tenancy
– Virtual Cloud Network is Hardware Enforced
• Higher Security Isolation
– No other tenants on system
• Higher Performance Isolation
– No other tenants running on system
– Control over density and overprovisioning
– Guaranteed instant upsizing of resources within
system
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 15
Oracle ATP vs. Microsoft Azure SQL Database
Security
Oracle ATP Microsoft Azure SQL Database
• Private Virtual Cloud Network • Database security
• Built-in database security – Transparent data encryption & Always encrypted
– Transparent data encryption & Always encrypted – Access Control
– Native Oracle Net encryption/encrypted IPsec VPN – Firewall
– Fine-Grained Access Control – Dynamic Data Masking
– Data Redaction – SQL Database Audit
– Data Masking / Dynamic Data Masking – Threat detection ($15/server/month additional)
– Audit Vault
– Automatic threat detection
– Database Vault
– Virtual Private Database
• Automated update of software security fixes
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 16
Oracle ATP vs. Microsoft Azure SQL Database
High Availability
Oracle ATP Microsoft Azure SQL Database
• Guarantee 99.995% uptime (2m 12s of downtime • 99.99% uptime for connectivity between Basic,
per month) – including maintenance Standard, or Premium Microsoft Azure SQL
• Maximum Availability Architecture Database and Microsoft Internet gateway
• Protection from hardware failures, software • Always On Availability Groups provide cluster of
crashes, patches, and updates with Active Data databases for high availability
Guard • Zone redundant DBs and elastic pools are only
• Uses RAC Database, redundant compute, supported in the Premium service tier. By default,
networking, triple mirrored storage, and daily backups and audit records are stored in RA-GRS
backup storage, and therefore, may not be automatically
available in case of a zone-wide outage
https://azure.microsoft.com/en-us/support/legal/sla/sql-database/v1_1/
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 17
Oracle ATP vs. Microsoft Azure SQL Database
Scalability
Oracle ATP Microsoft Azure SQL Database
• Based on Exadata; current capacity is: Max 128 • No scalability similar to Oracle Exadata optimized
OCPU (256 vCPU) & 128 TB DB size infrastructure. Current capacity is:
• Built upon Oracle RAC, you can scale beyond the – General Purpose: Max 80 vCore & 4 TB DB size
limits of a physical server while protecting against – Business Critical: Max 80 vCore & 4 TB DB size
server level failures – Hyperscale (preview): Max 80 vCore & 100 TB DB
size
• Instant online elasticity of serverless compute and
storage • No online elasticity of serverless compute and
storage
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-vcore
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 18
Oracle ATP vs. Microsoft Azure SQL Database
Tuning
Oracle ATP Microsoft Azure SQL Database
• ATP automatically tunes itself (indexes, memory, • Automatic tuning of database indexes and query
partitions, SQL plans, parallelism, and optimizer execution plans
stats) for the incoming workload as data changes
over time • Azure SQL Database identifies potential problems
in your database and recommends actions that
can improve performance of your workload by
providing recommendations
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-performance
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 19
Oracle ATP vs. Microsoft Azure SQL Database
Patching
Oracle ATP Microsoft Azure SQL Database
• Quarterly patching of all components (on-demand for • OS patching and database upgrades for Azure SQL
critical security issue) Database Managed Instance are handled
– Firmware, OS, Hypervisor, Clusterware, Database automatically with rolling service updates
– Installs prebuilt Gold Image of patched database • Limited information on patching for Microsoft
executables rather than directly applying patches Azure SQL Database Logical Server (Single
Database or Elastic Pool)
• Patching is automatically scheduled
– Customer can adjust timing within a time range
• Patches applied rolling across RAC nodes and Exadata
storage servers without downtime
– Database is continuously available to application
– Applications using Application Continuity best practices
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
run without interruption https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/03/07/what-is-azure-sql-database-managed-instance-2/
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 20
Oracle ATP vs. Microsoft Azure SQL Database
Cost
Oracle ATP Microsoft Azure SQL (Single DB Business Critical)
Product Pay As You Go Monthly Flex Metric Product vCore* License Included
Oracle ATP $2.5202/hr $1.6801/hr OCPU/hr Gen 4 1 - 24 $0.6795/hr - $16.31/hr
Oracle ATP – Gen 5 2 - 80 $1.3589/hr - $54.36/hr
$0.4839/hr $0.3226/hr OCPU/hr
BYOL
TB Storage 1 GB/month
Oracle ATP – Storage $0.25/GB (or $257/TB)
$222/TB/month $148/TB/month Capacity Per (1 GB increment to 4 TB)
Exadata Storage
Month RA-GRS $0.20/GB/month
Backup
ZRS $0.125/GB/month
Storage
LRS $0.10/GB/month
I/O Rate Free while in preview N/A
• Support fees are included in subscription Support Plans Starting at $29/month
• ML-driven automation cuts administration cost by
up to 80% (see LJE’s OOW keynote) * This is a separate DTU purchasing model.
https://azure.microsoft.com/en-us/pricing/details/sql-database/single/
https://cloud.oracle.com/en_US/atp/pricing https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vcore-resource-limits-single-databases
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 21
Microsoft Azure SQL Database Pricing
• Gen 4 - Up to 24 logical CPUs based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors, vCore = 1 PP
(physical core), 7 GB per core, attached SSD
• Gen 5 - Up to 80 logical CPUs based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, vCore=1 LP
(hyper-thread), 5.1 GB per core, fast eNVM SSD
https://azure.microsoft.com/en-us/blog/a-flexible-new-way-to-purchase-azure-sql-database/
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 22
Customer Case Studies
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 23
Oracle ATP In Action On NetSuite Workload
• Ran a complex Netsuite workload, and compared ATP to existing expert tuning
• 17,542 SQL statements, 1,852 tables, 8,151 indexes - years of tuning to create these indexes
– Before running on ATP, all indexes and statistics were dropped
1172 1155 4663
Elapsed Indexes
Expert Autonomous Expert
Time Used 1733
(sec)
Autonomous
ATP achieved identical performance to expert manual tuning
ATP stays tuned as workload changes
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 24
Analyst Perspectives
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 25
Analyst Perspectives
Gartner Critical Capabilities for Operational Database Management Systems
(published on 23 October 2018)
Operational &
Traditional Distributed Event Processing/
(Score 0 - 5) Analytics
Transactions Variable Data Data in Motion
Convergence
Oracle Database 4.40 4.20 4.25 4.33
Microsoft 4.23 4.15 4.05 4.18
SQL Server
This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner
document is available upon request from https://www.gartner.com/doc/reprints?id=1-5LPN68L&ct=181015&st=sb. Gartner does not endorse any vendor,
product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other
designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner
disclaims all warranties, express or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 26
Analyst Perspectives (cont.)
“WinterCorp recommends that “In the long run, we expect that “This product [ATP] represents a
customers begin experimenting autonomy (defined as machine major achievement in the history
with Oracle ATP without delay to learning adding optimization atop of database management.”
experience the simplicity, speed to database automation) will become
market and cost savings the norm with managed cloud
available.” database services (i.e. database-as-
a-service or DBaaS). Oracle is the
first database provider to go down
this path.”
http://www.oracle.com/us/corporate/analystreports/ http://www.oracle.com/us/corporate/analystreports/ovum-atp- http://idcdocserv.com/US44217218
wintercorp-oracle-atp-changes-game-5036079.pdf research-note-5036075.pdf
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 27
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 28
Oracle Market & Competitive Intelligence Copyright © 2019 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – For Internal Use Only 29
