Accelerating Dell Oracle 11g R2 Database Solutions Using PCIe Solid State Storage

The performance gap between server processing and the storage technology has been widening. Dell's latest 11G server product line is being shipped with multi-core Nehalem EP processors, which provide exceptional processing power. On the other hand, storage technology traditionally has lagged behind and database performance bottleneck is increasingly shifting towards the storage. Although the storage interconnect technology has been evolving over the years in all categories like FC, iSCSI, SAS and SATA, the backend disk rotational speed has topped at 15K due to physical and mechanical limitations. Solid State Storage (SSS) promises to narrow this gap between server and storage performance. There are many different types of Solid State Storage (SSS) devices available in the market today. The SSS can either be made available to the servers via the traditional FC, SAS, iSCSI interfaces or placed directly into the server PCIe slot without requiring traditional storage network interfaces. Since PCIe based SSS device sit directly in the server PCIe bus infrastructure, it promises the best SSS performance available to the database customers running applications which require sub-second query response times. With the addition of the Fusion-io's family of products, DellTM now even better enables customers with the speed of solid state storage technology for improved response time for I/O intensive database applications. In this white paper we will discuss various use cases of Dell's Fusion-io PCIe-SSS based solution with Oracle 11gR2 single node and Real Application Cluster databases.