Transcript Reference Architecture for OLTP HP Enterprise Transaction

Reference Architecture
for OLTP
HP Enterprise Transaction Processing
Reference Architecture Optimized for
Microsoft SQL Server 2008 R2
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Agenda
• Customer OLTP challenges
• Market trends
• Introducing: HP Transaction Processing Reference Architecture Optimized for Microsoft® SQL
Server 2008 R2
• Customer benefits and solution details
• HP versus competition
• Call to action
• Resources
2
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
The OLTP challenge
What we’ve heard from customers
• I need to ensure performance as the transaction load
increases
• This is critical to my business, I need Enterprise features
• I need a solution that is easy to maintain
• Help me reduce capital and operational expenses and give
me a future upgrade path
• I want flexible solutions that are from industry leaders
• I don’t want to be locked in to one vendor
3
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Market trends
What are your most challenging
database administration tasks?
• 47% of Gartner survey
respondents ranked data growth
in their top three challenges,
followed by system performance
and scalability
• Exploding transactional growth
is driving database performance
and availability needs to new
levels prompting the adoption of
new storage technologies, from
disk to solid-state
Patch upgrade
Performance/
21%
Tshoot 26%
Change
Management
14%
Performance/Tshoot
Resource issues
Security issues
Backup/rec
Rep/sync
Planning
Change Management
Patch upgrade
Resource issues
6%
Security issues
6%
Source: Gartner
Planning
11%
4
Rep/sync
8%
Backup/rec
8%
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Black Friday online sales increasing
much faster than in store sales
• Black Friday online sales jumped 26% YoY in 2011
• $816 million in sales according to ComScore
• 50 million Americans visited online
retails sites on Black Friday
5
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Market trends – Gartner's top 10 strategic
technology trends for 2012
8. In-memory computing:
“We will see huge use of flash memory in consumer devices, entertainment devices, equipment, and other
embedded IT systems. In addition, flash offers a new layer of the memory hierarchy in servers and client
computers that has key advantages -- space, heat, performance, and ruggedness among them. Unlike
RAM, the main memory in servers and PCs, flash memory is persistent even when power is removed. In that
way, it looks more like disk drives where we place information that must survive power-downs and reboots,
yet it has much of the speed of memory, far faster than a disk drive. As lower-cost -- and lower-quality -flash is used in the data center, software that can optimize the use of flash and minimize the endurance
cycles becomes critical. Users and IT providers should look at in-memory computing as a long-term
technology trend that could have a disruptive impact comparable to that of cloud computing” [17],
Cearley says.
By Michael Cooney, Created 2011-10
6
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP and Microsoft
A new portfolio that converges applications and infrastructure to deliver
business services
Complete
HP
Converged
Infrastructure
Agile
Optimized
7
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
What’s unique about us…
Better technology, better experience
Best-of-breed technologies
• HP Converged Infrastructure
• Business-critical applications
• Comprehensive management
Maximum performance
• Purpose built and optimized
• Deep application integration
• Best price/performance
Built on open standards
• Seamlessly integrates with
existing environments
• Modular for easy scaling
• Extensible to the cloud
8
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Introducing HP Enterprise Transaction Processing RA
Optimized for Microsoft SQL Server 2008 R2
Combining the power of HP Converged Infrastructure and
Microsoft SQL Server
• Up to 700,000 sustained IOPS (4k reads)
• 10x faster time to DB production: with faster warm-up, reduced backup and re-indexing times
• Leadership TCO compared to proprietary “one-size-fits-all” offerings
from other vendors
• Tier 1 SQL Database features optimized for OLTP workloads
• 100% flash-based storage for the SQL Database
HP ProLiant DL980 with
HP VMA-series Memory Array
9
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits of implementing Reference Architecture
Save time by deploying a proven RA with easy to follow:
• Configuration parameters
• Wiring diagrams
• Materials list (as built)
Avoid downtime
• Tested high availability (HA) configuration
• No single point of failure design
Service peace of mind
• HP Consulting and Support services for HW and SW (including SQL)
All products available today:
• HP ProLiant Servers (DL980)
• HP VMA-Series Memory Arrays
• HP Storage Back-up (D2D4324)
• Microsoft SQL Server 2008 R2
10
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits –
powerful performance
• 350,000 sustained IOPS (2 arrays) to 700,000 IOPS (4 arrays),
within 1 rack with 4k reads
• 100% persistent flash storage of entire DB
(not cached)
• HP PREMA Architecture improves performance across multiple
processors
• Scalable hardware
–
CPU to handle processing – up to 160 cores
–
RAM to speed up data access – up to 4TB ram
–
Scalable IO with 11 8x PCIe slots
• 10Gb network/8Gb SAN
• Fully Flash-based solution supporting up to 20TB of storage
11
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP ProLiant DL980 Server
HP PREMA Architecture to scale up with confidence
HP PREMA Architecture
• Up to 8 Intel® Xeon® processors
• Up to 10 cores and 30MB L3 cache per processor
Balanced scaling
• Up to 128 DDR3 DIMM slots; 4TB max memory
World record performance enabled by
Smart CPU Caching
• Up to 16 slots, PCI-E 2.0 or PCI-X
Self-healing resiliency
Resilient system fabric to maximize
uptime
ProLiant experience
Breakthrough efficiencies
Common and integrated experience with HP
iLO3, Insight Control, Thermal Logic
12
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP ProLiant DL980 world record performance
Enabled by HP PREMA Architecture
#1
Microsoft Windows® and SQL Server for two-tier
SAP Sales and Distribution (SD) standard application
benchmark
#1
Eight processor x86 single-node for SPEC CPU2006
#1
Microsoft Windows/SQL performance non-clustered
@ 1000GB and 3000GB for TPC-H
#1
Single-node J2EE/Java App Server for
SPECjAppServer2004
1. HP ProLiant DL980 G7 results at http://h18004.www1.hp.com/products/servers/benchmarks/index.html#8P as of 8/25/11
2. The SPEC logo is register trademark and © 2011 Standard Performance Evaluation Corporation (SPEC), reprinted with permission
13
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Top SQL workloads and applications
TOP STATS in production workloads
Largest single database
70 TB
Largest table
20 TB
Most data in a single app
88 PB
Data load time for 1TB
30 min.
Largest cube
12 TB
14
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Top SQL workloads and applications
Top partner benchmarks
5000 concurrent
users highest scale scale benchmark for TeamCenter
5203 TPS, 320 agents
Interest capitalization performance benchmark for T24
34,000 users
world-record scale for 3-tier SAP SD
9 million utility
meters/HP record scale data management for MDM
15
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Top SQL workloads and applications
TOP TPC benchmarks
TPC-E performance
10/10
TPC-E price/performance
10/10
TPC-C price/performance
4/10
TPC-H price/performance
10TB
TPC-H price/performance
3TB
16
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits – faster time to production
• DB warm-up time dramatically improved (up to 10x)
over disk-based systems
• Reduced DB maintenance windows with no drop in
transaction rate during re-indexing, backups, and other
database maintenance activities
• Fully tested, pre-configured set of components that
can be easily deployed
• Optional D2D backup device minimizes workload
impact
17
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Reduce your datacenter’s impact on the environment
HP VMA-Series Memory Array 3210
Capacity
Fully Flash-based
• 10TB storage, up to 7.6TB usable
• 84 x 128GB SLC solid state memory modules
• 80 active memory modules + 4 spare (hot-swap)
Reduced utilization of
•
•
•
Energy
Cooling
Floor space
Power: 900W (typical)
• Redundant and hot-swap
• 1100VA, 200+V
Performance
•
•
•
•
18
PCIe: 20 Gb/s
25/80 µsec W/R latency
250K IOPS writes, 350K IOPS reads (4K block)
Endurance: up to 8TB writes/Hr for five years
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits – high availability
• No single point of failure between architecture components
• Built-in internal resiliency with
HP ProLiant DL980 servers
• Built-in redundancy of data in
HP VMA-Series Memory Arrays
• Reduced or zero downtime for
HW maintenance
• HA options include clustered
SAN configurations
19
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
DL980 self-healing resiliency through innovations on
industry standards
DL980 exclusive
HP PREMA Architecture
Resiliency
Dynamic routing on system fabric
enhanced MCA logging
System resiliency
OS enhanced availability
Link Level Retry
Corruption prevention
Hot plug RAID
Advanced memory protection
200% boost in server availability
• Advanced reliability with
resilient system fabric
• Leverages mission- critical designs
of HP Superdome 2
•
CPU resiliency
Machine Check Architecture
20
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Breakthrough efficiencies
Delivering a common and integrated infrastructure
Remote
Management
•
•
Intelligent common modular component
usage with platinum level 94%
high-efficiency power supplies
800% faster remote console and 3.6x faster
virtual media
21
Insight
Software
•
•
•
Thermal
Logic
12x increase in deployment speed and >$47k in
savings per 100 users
Reduce unplanned downtime by up to 77%
Reduce, reclaim, and extend the life of your
datacenter
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits – reduced cost
• Fully tested and configured solution – faster to implement and deploy
• Many competitive wins versus Oracle Exadata with customers experiencing dramatic
cost savings
• Fully upgradeable to Microsoft SQL Server 2012
• Simple administration does not require third-party consultant to manage (unlike
Oracle RAC)
• Common and integrated experience with HP iLO3, Insight Control, and Thermal Logic
for reduced system management
• Reduced floor space cost with single rack solution
22
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP Thermal Logic technologies
Helping deliver the Converged Infrastructure today
Reclaim
Reclaim power capacity with HP Insight Control
Power Management Software
Bottlenecks in production systems
Reduce
Extend
Reduce energy consumption with efficient
product design
Extend the life of your data center with a
power-efficient ecosystem
Portfolio of embedded HP technologies along with innovative tools and products that maximize
data center efficiency and accelerate customer ROI
23
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP Insight Control Remote Management
Best-in-class infrastructure management
HP iLO 3 with ProLiant gives you a new level of remote management
Bottlenecks in production systems
Turbo-charged performance
Streamlined interface
Enhanced standards support
• 800% faster remote console – as
good as being there in person
• Monitor scales to the resolution
of your client, regardless of size
• Industrial strength security
with AES Encryption
• 360% faster virtual media
enabling faster set-up and update
• Simplified tree view for immediate
access to all iLO functions
• Simple server control in
scale-out environments
Get work done faster with iLO 3
24
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Benefits of implementing Reference Architecture
1
2
3
All products available
today:
Avoid downtime
Save time by building a
proven RA with easy to
follow:
•
•
•
•
•
HP Converged Infrastructure
Amazing performance
TCO leadership
Full support from HP
25
•
Tested HA configuration
No single point of failure design
with business growth
•
•
•
Configuration parameters
Wiring diagrams
Materials list (as built) features
for SQL based OLTP workloads
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
What Oracle does not tell you
26
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP OLTP RA versus Oracle Exadata – feature
comparison
Feature
HP OLTP RA
Exadata X2-8
Sustained IOPS
700k/second
200k/second (estimated maximum)
Database Cache warm-up
20 min.
As much as 3 hours
Database Storage Media
100% persistent flash storage
for entire DB
90% disk, 10% flash Cache (requires static table, index or partition
placement on 14 storage nodes)
CPU Cores
160
128
Memory
4TB
2TB
Database Compression
Type
Page or Row Level
Columnar (not suited for OLTP)
27
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
More trustworthy
Source: NIST National Vulnerability Database
Vulnerabilities are included for SQL Server 2000, SQL Server 2005, SQL Server 2008. Oracle (8i, 9i, 9iR2, 10g, 10gR2,11g)
Source: Aggregated vulnerability data from Secunia ©
*RHEL 5 had 114 and WS08 had 25 vulnerabilities
28
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP support provides peace of mind
• Get peace of mind with the end-to-end support from HP for all components of the HP OLTP RA,
including the Microsoft software
• HP recommends HP Critical Advantage to meet the mission-critical needs of the HP OLTP RA
• HP also offers a choice of reactive and proactive support levels to meet your specific business
needs
• HP has recognized Microsoft expertise with 23,000 Microsoft-trained and more than 11,000
Microsoft certified professionals
• HP has one of the largest, most specialized forces of consultants and support professionals for
Microsoft environments
29
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Unmatched 25+year HP-Microsoft partnership
• HP has won the Microsoft "Global Enterprise
Partner of the Year” on numerous occasions
• Over a decade of joint engineering to deliver
robust Windows and SQL Server solutions
–
Work closely with the Windows OS teams, SQL
teams, and Hyper-V teams to ensure optimum
scalability and performance
• Leading end-to-end solutions reflected in
#1 Windows market share
• Proven value for business-critical Windows
environments
30
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Next steps
Resources and other tools
•
•
•
•
Download the OLTP Solution Brief for key HP/MSFT differentiation
Learn more with the detailed OLTP Reference Architecture
Request a technical deep dive with HP and MSFT Solution Architects
Learn more about HP/Microsoft I2A solutions
31
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Thank you
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.