Posted on behalf of Kai Yu.

The Dell PowerEdge Express Flash PCIe SSD is an enterprise class high performance storage device designed for applications that require low latency and high IOs Per Second (IOPs) operation. It is built with SLC NAND flash and can be used as an internal storage of Dell PowerEdge servers.  This not only removes the performance bottleneck posted by the mechanical parts of conventional HDDs, also improves the storage IO performance by eliminating the latency and performance bottleneck between the server and the external storage. 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 Express Flash PCIe SSDs to improve the performance. To understand how PCIe SSDs 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 (Redhat Compatible Kernel) platform.

This article explored three use case of using PCIe SSDs to optimize Oracle database:
1) Use PCIe SSDs as the primary database storage
2) Use PCIe SSDs as a part of tiered storage combining with conventional hard disk storage
3) Use PCIe SSDs as an extension of database cache with the Oracle database smart flash cache feature.

The attached whitepaper document explores in detail these use cases of Dell PowerEdge Express Flash PCIe SSD based solutions with Oracle 11gR2 single node and Real Application Cluster databases and the performance comparison results with these cases.

About the Author:

Kai YuSenior System Engineer, Dell Oracle Solutions Engineering

  • 17 years with Oracle Technology: DBA, Apps DBA, Engineer/Architect
  • Oracle ACE Director, author and presenter
  • 2011 OAUG Innovator of the Year Award Winner
  • Oracle Blog: