EMC Optimized Flash Storage for Oracle Databases

Bitly URL:

http://bit.ly/1r3AXbg

 

Tweet this document:

Chasing the #Oracle active data set a new paper by @kevinclosson http://bit.ly/1r3AXbg #EMC Optimized Flash Storage for Oracle Databases

 

#XtremIO delivered more IOPS, lower latency, and a vastly superior latency histogram http://bit.ly/1r3AXbg Learn more, read the new paper!

 

Mixed 8 KB IOPS increased from 99,000 with one X-Brick to 190,000 with 1-millisecond service times with two XBricks bit.ly/1r3AXbg

 

Other XtremIO Content:

XtremIO Snapshots are Different

 

Virtual Storage Zone: Getting The Best Oracle Performance on XtremIO

 

XtremIO Best Practices: Advanced Format 512e and Native modes

 

Features and Benefits of using Oracle in XtremIO

 

Follow us on Twitter:

EMCOracle.jpeg.jpg

 

Visit the EMC store:

store_open-218x245.png

Click here to learn more about EMC’s Solutions for Oracle

Chasing Active Data Set


The goal of this new EMC white paper by Kevin Closson is to help the reader understand Oracle performance bottlenecks and how XtremIO can help address these performance issues.

 

Summary


EMC conducted testing for Oracle RAC environments connected to a dual X-Brick XtremIO Array in an OLTP-style workload with 75% select and 25% SQL updates with a 1TB active data set over an 8 hour period. The graph below shows the consistently fast performance of the XtremIO array when gradually increasing from 192 connections per RAC host to 368 connections during a 60 minute test. The number of IOPS increased 17% and the average services remained relatively flat: ranging from a low of .96ms to a pick of 1.36ms. It’s clear from this test that XtremIO keeps the services times predictably low even when the number of database connections near double!

XIO-predictable-service-times.png









XtremIO has shown the ability to support a 2X increase in the number of Oracle user sessions and maintain predictable service times, while still driving an increase in IOPS of ~20%.


EMC then expanded this test to use an 11TB data set, with 100% SQL update workloads over a 24 hour period. The XtremIO array was able to sustain 64% more total IOPs with a 1.07 ms average response time compared to 3.49 ms from the competitor array. The result is XtremIO delivered 48-80% more physical database I/O with 3X less latency on average.


Today, XtremIO can scale from one X-Brick to two, four or six X-Bricks to provide your database with near linear scalability. In further testing, EMC engineers created an Oracle 11gR2 RAC database on a two-node cluster attached to XtremIO. An Oracle 60 minute performance test was conducted using a single X-Brick configuration and

then repeated across two X-Bricks.

XtremIOScalability.png








The findings show:

  • Random reads scaled at 96% of linear scalability
  • Writes scaled at 98% of linear scalability
  • Redo logging and SQL executions scaled linearly

 

This paper is a must read for the Oracle DBA interested in using XtremIO to drive superior database performance!

 

Chapters from the Table of Contents:

  • Introduction
  • Oracle Database In Low Latency Computing
  • An Optimal Time Model For Oracle
  • Architectures Impact Sustainability Of Service Times
  • Summary


Visit the EMC Store for XtremIO!

XtremIO2.pngBring all-flash, scale-out storage to your enterprise applications with EMC XtremIO. Purpose-built for flash, XtremIO storage arrays are amazingly fast. Delivering high IOPS at less than 1 millisecond latency is just the start. EMC XtremIO helps you harness the power of flash storage by building in innovations like content-based data placement and dual-stage metadata.

 

As a result, you’ll have predictable and balanced performance, always-on data reduction, thin provisioning, data protection, writeable snapshots, encryption, and simple storage provisioning. Ideal for virtual desktop infrastructure (VDI), virtual server infrastructure, databases and analytics, and mixed workload consolidation.

 

  • Expands to more than 270 TB logical capacity per cluster
  • Inherently load balances data for maximum performance without tuning
  • Provides writeable snapshots with space efficiency and zero performance impact
  • Includes unique XtremIO Data Protection (XDP): more resilient and lower overhead than legacy RAID* Delivers truly inline, always-on data deduplication to reduce capacity needs and TCO