Optimizing OLTP Oracle database performance using Dell express flash PCIe SSDs

Executive summary

The Dell PowerEdge Express Flash PCIe SSD is an enterprise class high performance storage device. It is built with SLC NAND flash and designed for applications that require low latency and high IOPs (IO Per Second) operation. OLTP database workloads which require very low storage IO latency with many small random read/write IO operations are the ideal cases to use Dell Flash PCIe SSDs to improve the performance. To understand how much PCIe SSDs can really improve OLTP database performance, several performance studies have been conducted on a single node Oracle 11g R2 database as well as a two node 11gR2 Oracle Real Application Clusters (RAC) database running on Dell PowerEdge R720 servers with Oracle Linux 6.2 platform. This article is to show these case studies and some preliminary performance comparison results.

Full Whitepaper

Download the full whitepaper here: http://downloads.dell.com/solutions/enterprise-solution-resources/PCIe_SSD_for_oracle_database_performance.pdf