Transcript How To Compete and Win Against Oracle

How To Compete And
Win Against Oracle
Nick Ward
Product Technology Specialist
Microsoft Australia Pty Ltd
Agenda
Understanding Oracle
How to compete
SQL Server Enterprise Capabilities
TCO Comparison
SQL Server Momentum
Questions and answers
How To Compete?
Understand
Customer’s
Requirements
Show SQL Server
can meet and exceed
customer’s requirements
Show SQL Server offers
a better value than Oracle
SQL Server
Ready for the Enterprise
Scalability and Performance
High Availability
Security
Business Intelligence
Winter Corporation Top Ten
For 2005
3rd largest OLTP database in the world by rows
Verizon Communication’s COFEE at 52 billion rows
6th, 7th & 10th largest OLTP databases
in the world by volume
Aim Healthcare at 8.1 Terabytes
Verizon at 7.8 Terabytes
8th largest data warehouse database
in the world
UPSS: Unisys Payments Services & Solutions
at 19.5 Terabytes
http://wintercorp.com
SQL Server 2005 TB+ Customers
3 TB Retail data warehouse on HP Superdome
Uses SQL Server OLAP, SSIS, SSRS
5.1 TB Credit Card DW, 5 Mil card holders
Uses SQL Server OLAP, SSIS, SSRS, Office BSM
4 TB Consumer Packaged Goods (CPG) DW
350 users, Complex relational query, SSIS & SSRS
1 TB Real-time store efficiency system
Data is bulk loaded continually and daily
2.2 TB SAP Business Warehouse system
In the process of migrating SAP R/3 OLTP to SS2005
2 TB system originally migrated from Informix
300 users, Complex query, OLAP, Data Mining
Platform Of Choice
3.5X Scalability!
Leading Platform For New
SAP Installations
42x
Max number of concurrent users
75%
Growth!
50%
HP Integrity Superdome
25%
0%
1994 1998
SAP SD three-tier standard application benchmarks #2002007, and other to be assigned
2002
2005
% of New SAP Installations On Windows and SQL Server
World class scalability and unprecedented price/performance
for running SAP business applications on SQL Server 2005
4P
206K tpmC
2.30 $ / tpmC
16P
IBM: 492K tpmC
Unisys: 3.97 $/tpmC
64P
1.2M tpmC
TPC-C results to the left: HP ProLiant DL585-G1 206,181 tpmC, 2.30 $/tpmC, available 11/7/05; IBM eServer
xSeries 460 16P c/s, 492,307 tpmC, 6.37 $/tpmC, available 5/20/2006; Unisys ES7000/600 Enterprise Server
(16P), 376,045 tpmC, 3.97 $/tpmC, available 1/3/2006; HP Integrity Superdome, 1,231,434 tpmC, 4.91 $/tpmC,
available 5/5/06. Results as of 11/28/05.
100 GB
12,600 QphH
9.43 $/QphH
1 TB
16P
HP: 17,725 QphH
Bull: 25.48 $/QphH
3 TB
32P
30,956 QphH
TPC-H results above: HP ProLiant DL585-G1 12,600 QphH@100GB, 9.43 $/QphH@100GB, available 11/7/05;
Bull NovaScale 5160, 17,059 QphH@1TB, 25.48 $/QphH@1TB, available 5/5/06; HP Integrity Superdome, 30,956
QphH@3TB, 76.82 $/QphH@3TB, available 5/5/06; NEC Express5800/1320Xe, 28,390 QphH@3TB, 66.52
$/QphH@3TB, available 5/5/06. Results as of 11/27/05.
TPC-C Benchmarks
TPC-H Benchmarks
SQL Server Availability
99.999% availability, Telecom
12000 concurrent users, 5 TB of data
99.999% availability, Gift Card Processor
500 concurrent users
99% availability, Paper Manufacturing
433 tps
100% availability, Manufacturing
900 tps
99.990% availability, Retail
2000 concurrent users
99.998% availability, Stock Exchange
3200 tps
99.997% availability, Banking
500 tps
Right-click logo, and open Hyperlink for public case-study, where available
SQL Server
Fewer vulnerabilities, fewer patches,
easier to administer
Database Security Bulletins
74
50
20
21
13
11
2
2002
2003
SQL Server
1
2004
2005
Oracle DB
2006
Oracle’s Security Response
“Oracle is years behind Microsoft
and other companies on security,"
said Cesar Cerrudo, CEO, at
information security services
company Argeniss, in Argentina.
"I think Oracle is an amateur
when it comes to security."
Oracle’s Security Response
“Serious unpatched security
flaws exist in certain Oracle
products.” according to a German
security researcher who said the
software maker has not fixed the
bugs despite knowing about
them for two years.
Integrate


Data acquisition from
source systems
and integration
Data transformation
and synthesis
Analyze


Data enrichment,
with business logic,
hierarchical views
Data discovery via
data mining
Report


Data presentation
and distribution
Data access for
the masses
Complete. Integrated. Included.
Key Components Of Database
Total Cost Of Ownership
Influenced mostly by:
Software License Cost
License Price
Support and
Maintenance Cost
Support Fees
Hardware Cost
Price Performance
Application
Development Cost
Developer Productivity
Ongoing
Administration Cost
DBA Productivity
Database Total
Cost of Ownership
Oracle 10g
Base Product
$ 25K
$ 40K
Tuning
$3K
Diagnostics
$3K
Partitioning
$10K
(included)
Manageability
Base Product
$ 25K
$ 56K
40K
OLAP
$20K
Mining
$20K
BI Bundle
$20K
Business
Intelligence
(included)
Manageability
Base Product
$ 25K
$$ 116K
56K
Data Guard
$116K
High Availability
Business
Intelligence
(included)
Manageability
Base Product
$ 25K
$ 232K
116K
$116K - $232K
Multi-core
Business
Intelligence
High Availability
(included)
Manageability
Base Product
$ 25K
$348k
- $464k
$ 232K
Customer Testimonial
"Adding things like a reporting solution or
OLAP services; The costs just kept building
up on the Oracle side while they remained
the same on the SQL Server side."
—Adam Solesby,
Director of Strategic Development,
AIM Healthcare Services
Oracle And SQL Server: Support
And Maintenance Cost Comparison
Scenario: 3 year support for a 4 CPU server
Product Support: SQL Server is 37% lower than Oracle
Product + Premier Support: SQL Server is 25% lower than Oracle
Lower Hardware Costs
Due to better price performance
Server Class
Small Servers
Medium Servers
High-End Servers
Number SQL Server’s
of CPUs
Best
Oracle’s
Best
Advantage
1
$0.99
No Result
SQL Server
2
$1.80
$1.81
SQL Server
4
$2.04
$3.94
SQL Server
8
$3.96
$5.26
SQL Server
16
$3.97
$4.40
SQL Server
64
$5.52
$8.33
SQL Server
TPC-C results referenced in the price/performance comparison table are: Dell PowerEdge 2800, 38,622 tpmC, 0.99 $/tpmC, available 11/8/05, HP ProLiant
ML370-G4-1M, 68,010 tpmC, 1.80 $/tpmC, available 11/1/04, HP Integrity rx2600, 51,506 tpmC, 1.81 $/tpmC, available 9/29/04, HP ProLiant DL585-G1,
187,296 tpmC, 2.04 $/tpmC, available 5/31/05, IBM eServer p5 570, 203,439 tpmC, 3.93 $/tpmC, available 10/17/05, HP ProLiant DL760G2, 143,367 tpmC,
3.96 $/tpmC, available 5/6/04, IBM eServer p570, 371,044 tpmC, 5.26 $/tpmC, available 9/30/04, Unisys ES7000/600 Enterprise Server, 376,045 tpmC, 3.97
$/tpmC, available 1/3/06, Unisys ES7000 Aries 420 Enterprise Server, 327,829 tpmC, 4.40 $/tpmC, available 7/29/05, HP Integrity Superdome, 1,082,203 tpmC,
5.38 $/tpmC, available 12/7/05, HP Integrity Superdome, 1,008,144 tpmC, 8.33 $/tpmC, available 4/14/04,
Results as of 10/25/05.
http://www.microsoft.com/sql/evaluation/compare/tpcc.mspx
Developer Productivity
Comparison Study
Final outcome
Oracle 10g Developer required 4 times the amount
of time required by the SQL Server developer
The developer study was conducted by 3 Leaf Corporation. The complete report is available at:
http://www.microsoft.com/sql/prodinfo/compare/oracle/devprodoracle.mspx
DBA Productivity Survey
Alinean Research, 2006
SQL Server DBAs manage over 3 times as
many databases as Oracle DBAs
SQL Server DBAs support over 20% more
end-users than Oracle DBAs
Annual cost of administering an Oracle DB
is over 3 ½ times of that for SQL Server
SQL Server
Lower Overall TCO than Oracle
Lower Administration Cost
Lower Application
Development Cost
Lower Software License Cost
Lower Hardware Cost
Server Class
Small Servers
Lower Support Cost
Number
of
CPUs
SQL
Server’s
Best
Oracle’s
Best
Advantage
1
$0.99
No Result
SQL Server
2
$1.80
$1.81
SQL Server
4
$2.04
$3.94
SQL Server
8
$3.96
$5.26
SQL Server
16
$3.97
$4.40
SQL Server
64
$5.52
$8.33
SQL Server
Medium Servers
High-End Servers
For More Information
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx
!!!SQL Server Momentum!!!
Revenue Growth Rate %
2005 – Highlights
2006 – Highlights
Highest growth in 2005, twice
as fast as market at 8.6%
Only vendor that gained share,
1%+ in $14B market
30%+ growth in Q1 CY06
Even higher growth expected in
Q2 CY06
30%+
30%
17%
8%
6%
2005
Source: Gartner
Q1 2006
Q2 2006
Source:
Source:
DBMS Market (Australia)
Gartner Research, 2004
Microsoft surpasses Oracle in market share!
Top 3 Databases 87%
Gartner Report from Local Market Intelligence team
New License Rev for DBMS 2004 Asia Pacific
© 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES,
EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.