ASM Best Practices Optimizing Storage for Asm

Please download to get full document.

View again

of 14
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 5 | Pages: 14

Extension: PDF | Download: 0

Share
Related documents
Description
ASM Best Practices Optimizing Storage for Asm
Tags
Transcript
    Best Practices for Optimizing Storage for Oracle  Automatic Storage Management with Oracle FS1 Series Storage ORACLE WHITE PAPER | JANUARY 2015    BEST PRACTICES FOR OPTIMIZING STORAGE FOR ORACLE AUTOMATIC STORAGE MANAGEMENT WITH ORACLE FS1 SERIES STORAGE Table of Contents 0 Introduction 1 The Test Environment 1 Best Practices 5 Oracle Automatic Storage Management Disk Groups Recommendations 5 Recommendation #1 6 Recommendation #2 7 Recommendation #3 7 QoS Plus Recommendations 8 Recommendation #4 8 Storage Domain and Autotiering Recommendations 9 Recommendation #5 9 Recommendation #6 10 Summary 10     1 | BEST PRACTICES FOR OPTIMIZING STORAGE FOR ORACLE AUTOMATIC STORAGE MANAGEMENT WITH ORACLE FS1 SERIES STORAGE Introduction Oracle Automatic Storage Management capability of Oracle Database might conflict with SAN or NAS storage system management operations. This paper describes the coengineering advantage of using Oracle FS1 Series storage systems with Oracle Automatic Storage Management to drive performance at flash speed and latency, automate storage provisioning, and simplify management. In addition, the paper includes best practices for leveraging application profiles and the QoS Plus feature of Oracle FS1 Series storage systems. QoS Plus delivers quality of service (QoS) capabilities that automatically provision storage systems to get and maintain optimum performance and efficiency using flash in the Oracle Automatic Storage Management environment. Further, the paper describes how to configure a system comprising Oracle Database 12 c   with Oracle  Automatic Storage Management on Oracle Linux, using an Oracle FS1 Series flash storage system. It assumes that you know how to configure each of the individual components (Oracle Database 12 c  , Oracle Automatic Storage Management, Oracle Linux, and Oracle FS1 Series storage systems), but you need to know the best practices for making these components work well together. The primary aim of this document is to give you the settings that will quickly get you to 80 to 90 percent performance. Of course, your particular environment and applications are different from those outlined in this paper; hence, you will need to perform a final tuning of settings that can give you the best performance.  A secondary aim of this paper is to give you detail about how the Oracle team determined these configuration settings. Then you can repeat these tests in your environment, adjusting the workloads to more closely match your applications. While the testing outlined in this paper was undertaken against the Oracle Database 12 c   release, the testing and results should be equally applicable for Oracle Database 11 g   Release 2. The Test Environment Figure 1 shows the physical setup. Starting from the left, it shows an Oracle FS1-2 flash storage system connected to a 16 Gb/sec Fibre Channel (FC) switch. The red lines indicate multipathing FC connections. The switch is connected to two Sun Server X4-2 servers from Oracle that run Oracle Database 12 c   as an Oracle Real Application Clusters (Oracle RAC) cluster. A third server is used for running workload generators. This is connected to the database servers by standard Ethernet/IP networking.    2 | BEST PRACTICES FOR OPTIMIZING STORAGE FOR ORACLE AUTOMATIC STORAGE MANAGEMENT WITH ORACLE FS1 SERIES STORAGE Figure 1. Physical setup Figure 2 shows the same setup but from a logical, rather than physical, perspective. Starting at the bottom of the stack, the Oracle FS1-2 storage system appears with its four types of storage media and two controllers. The DBA or storage administrator creates virtual disks (LUNs) on the array, and these are what the next layer up (Oracle  Automatic Storage Management) sees. Oracle Automatic Storage Management groups the LUNs into disk groups and presents these to Oracle Database 12 c  . Above the database layer, there is an IP load balancer that evenly distributes the database requests coming from the workload generators to the nodes of the Oracle RAC cluster. Figure 2. Logical setup In terms of workload generators, two very different pieces of software are used. The first is a program called Swingbench (http://dominicgiles.com/swingbench.html). This is a load generator designed to simulate the operation of a real application and to stress test Oracle Database. It consists of a load generator, as well as tools for scheduling and coordinating multiple instances of the load generator when deployed for very large workloads. As Figure 3 shows, it includes a nice GUI for ease of use.
Recommended
View more...
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks