Optimizing OLTP Oracle database performance using Dell express flash PCIe SSDs
Summary: optimizing OLTP oracle database performance using dell express flash PCIe SSDs
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
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
Article Properties
Article Number: 000146494
Article Type: Solution
Last Modified: 21 Feb 2021
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.