Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS

 Existing traditional spinning HDD-based storage environments that cannot grow in performance

because storage controller has reached its maximum processing capabilities. This can be

achieved by replacing their existing single node database server with a Dell’s PowerEdge server

that supports Dell PowerEdge Express Flash PCIe SSDs and configured with Dell Fluid Cache for

DAS.

 New single node DAS solutions looking for low latency, high TPS for OLTP databases.

 Single or multiple large OLTP databases (>700GB) looking for low latency and high TPS

performance and that cannot be consolidated directly onto the server-side PCIe SSDs.

References

1. Dell™ PowerVault™ MD1200 and MD1220 Storage Enclosures Hardware Owner’s Manual

http://support.dell.com/support/edocs/systems/md1220/en/HOM/PDF/HOMA00EN.pdf

2. Dell PowerEdge RAID Controller (PERC) H310, H710, H710P, and H810 User’s Guide

http://support.dell.com/support/edocs/storage/Storlink/PERC_8/en/UG_PERC8_en.pdf

3. Comprehending the Tradeoffs between Deploying Oracle

Database on RAID 5 and RAID 10 Storage

Configurations

http://i.dell.com/sites/content/business/solutions/whitepapers/en/Documents/tradeoffs-raid-5-

raid-10.pdf

4. Single node single instance Oracle

11gR2 database installation guide

http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/3885.4-1-1-1-

0-how-do-i-install-a-standalone-oracle-database.aspx

5. Dell PowerEdge Express Flash PCIe SSD user’s guide

ftp://ftp.dell.com/Manuals/all-products/esuprt_ser_stor_net/esuprt_dell_adapters/dell-

poweredge-exp-fsh-pcie-ssd_User%27s%20Guide_en-us.pdf

6. Dell PowerEdge R720

http://www.dell.com/us/enterprise/p/poweredge-r720/pd?~ck=anav

7. Dell Quest Benchmark Factory (BMF)

http://www.quest.com/benchmark-factory/

8. Dell Fluid Cache for DAS

User’s guide can be found at: www.dell.com/support