Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS
iii
Contents
Executive summary ..................................................................................................... 5
Introduction .............................................................................................................. 5
Dell Fluid Cache for DAS Overview ................................................................................. 6
Solution design and reference architecture ........................................................................ 6
Traditional HDD-based storage solution (Baseline Configuration) ............................................ 7
Fluid Cache for DAS-based storage solution (Fluid Cache) ..................................................... 9
Test methodology ..................................................................................................... 11
Test environment .................................................................................................... 11
Baseline configuration test methodology ....................................................................... 11
Fluid Cache based solution test methodology .................................................................. 13
Performance results and analysis .................................................................................. 14
Conclusion .............................................................................................................. 19
References ............................................................................................................. 20
Appendix A. Server configuration ................................................................................. 21
Appendix B. Backend storage configuration .................................................................... 22
Appendix C. Software configuration ............................................................................. 23
Appendix C.1. Fluid Cache based solution configuration .................................................. 24
Appendix C.2. Setting up ownership and permission for Oracle disks ................................... 26
Appendix C.3. ASM diskgroup configuration .................................................................. 28
Appendix C.4. Parameter settings ............................................................................. 29
Appendix C.4.1. Kernel parameter settings .................................................................. 29
Appendix C.4.2. User security limits settings ................................................................ 30
Appendix C.4.3. Oracle database parameter settings ...................................................... 30
Appendix D. Next Steps ............................................................................................. 31
Appendix D.1. Fluid Cache for DAS Reference Architecture Solution ID ................................ 31
Appendix D.2. Database management software ............................................................. 31
Tables
Table 1. Server configuration details for baseline configuration ........................................... 21
Table 2. Server configuration details for Fluid Cache based solution ..................................... 21
Table 3. Backend storage configuration ........................................................................ 22
Table 4. Virtual Disk configuration for baseline. .............................................................. 22