ASM EVA Best Practices White Paper | Hewlett Packard | Databases

Please download to get full document.

View again

of 32
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: 2 | Pages: 32

Extension: PDF | Download: 0

Share
Related documents
Description
Best practices for Oracle 10g with Automatic Storage Management (ASM) and HP StorageWorks 8000 Enterprise Virtual Array 8000 white paper Environment: Oracle 10g with ASM on both single instance database and Real Application Clusters (RAC) using HP ProLiant DL580 servers running Window 2003 Enterprise Edition with HP StorageWorks EVA8000 Executive summary............................................................................................................................... 3 Key findings.
Transcript
  Best practices for Oracle 10g with Automatic Storage Management(ASM) and HP StorageWorks 8000 Enterprise Virtual Array 8000white paper Environment: Oracle 10g with ASM on both single instance database and Real ApplicationClusters (RAC) using HP ProLiant DL580 servers running Window 2003 Enterprise Edition withHP StorageWorks EVA8000 Executive summary...............................................................................................................................3   Key findings........................................................................................................................................3   Overview............................................................................................................................................3   Components........................................................................................................................................4   Configuring the hardware.....................................................................................................................6   Configuring the EVA8000 storage array............................................................................................8   Configuring the HP ProLiant DL580 server...........................................................................................8   Configuring the software......................................................................................................................8   Configuring the MPIO driver.............................................................................................................8   Configuring Windows for ASM.........................................................................................................9   Using 32-bit Windows......................................................................................................................9   Modifying ASM hidden parameters..................................................................................................10    Working with Benchmark Factory....................................................................................................12    ASM performance results....................................................................................................................16   Batch test results.............................................................................................................................17   OLTP test results.............................................................................................................................18   DSS test results...............................................................................................................................21   Conclusions......................................................................................................................................26   Summary of results.........................................................................................................................26   Project learnings............................................................................................................................26   Best practices....................................................................................................................................27   Best practices for Storage Administrators..........................................................................................27   Best practices for Server Administrators............................................................................................27   Best practices for Database Administrators........................................................................................27    Appendix A. Bill of Materials..............................................................................................................28    Appendix B. Examples.......................................................................................................................29   For more information..........................................................................................................................32   HP technical references...................................................................................................................32   HP solutions and training................................................................................................................32    HP product sites.............................................................................................................................32   Oracle..........................................................................................................................................32   Quest Software..............................................................................................................................32    Executive summary Improve profitability, manage risk, and lower TCO with HP StorageWorks Application-BasedSolutions. In this project, the HP StorageWorks Customer Focused Test team provided best practicesand optimal performance for configuring an Oracle® 10g database with Automatic StorageManagement (ASM) on the HP StorageWorks 8000 Enterprise Virtual Array (EVA8000). A speciallook into the ASM disk group and EVA disk group configurations is the critical emphasis of thisproject. Results of this testing include the optimal EVA8000 configuration with respect to disk groups,database file layout, and mapping to corresponding ASM disk groups.The following questions were specifically addressed in this project: ã    What is the best method to map Oracle/ASM data extents to EVA disk groups? ã   Is there an advantage for “double-striping” in which the hardware and software are striping thedata across the same physical disks? ã    What is the recommended configuration for an Oracle/ASM database on the EVA? ã   Does this recommendation change based on workload type, that is, batch, Online TransactionProcessing (OLTP), and Decision Support Systems (DSS)? ã   Does this recommendation change based on single instance database or Real Application Clusters(RAC)? Key findings Testing successfully provided the following high-level results: ã    ASM striping can improve database performance in conjunction with EVA virtualization. ã   The EVA configuration for batch loading of 500 GB was not significant. All configurationsperformed equally well. ã   The EVA configuration for OLTP testing shows an advantage toward a configuration that uses both ASM and EVA striping (double-striping). The advantages were more pronounced as the databasesize increased (2.5-TB RAC database with 1,000 concurrent users). ã   The greatest benefit from double-striping was most noticeable with DSS workloads. Obviousdifferences in the configurations were observed, especially with the 2.5-TB RAC database with nineconcurrent users running a portion of the DSS power test. ã   Even greater performance on DSS workloads can be achieved by modifying one of the ASMhidden parameters, allocation unit size, to maximize data placement on the EVA.Important findings uncovered during the tests are documented in theBest practicessection. Overview The main purpose of the project was to test various EVA disk group configurations and determine thebest configuration when running an Oracle 10g database with ASM. The introduction of Oracle ASMcapabilities in Oracle 10g provided alternative storage management options to those available in thestorage hardware alone. ASM provides some similar functionality to the HP StorageWorks EVA.Customers want to understand where the functionality overlaps, if they can co-exist, and if so, what isthe best way to configure HP StorageWorks EVA storage to optimize application performance undervarious database workloads? 3  Several test scenarios were evaluated in regards to their impact on database performance: ã   EVA configurations —Three EVA configurations were tested to see how Oracle performed during thebenchmark testing. ã   Benchmarks —Three industry-standard benchmarks (batch, OLTP, and DSS) were run against theEVA configurations. The intent was to see if the best practices changed with differing workloads,that is, did a particular EVA configuration perform better with DSS workload than with an OLTPworkload? ã   Database type —Both single instance and RAC databases were tested to see if clustering had anyeffect on the overall best practice. Components To run these tests, HP configured the systems illustrated in Figure 1 and Figure 2. These environmentswere based on input from customers and are representative of typical Oracle database environments.The key components include the following: ã   Oracle 10g—Quest Software’s Benchmark Factory for Databases was used to generate standardOracle workloads against the Oracle database in a variety of workload types (batch, OLTP, andDSS). ã   HP ProLiant DL580 server—This server was used to host the Oracle database. Two configurationswere used—a single instance database (Figure 1) and a two-node RAC instance (Figure 2). ã   HP ProLiant BL20p server—This server was used to host the necessary storage managementsoftware (HP StorageWorks Command View EVA) for monitoring and configuring the storagearray. Also, the storage performance metrics from EVAPerf were managed from this server. ã   EVA8000—SAN-based storage array that stored the Oracle database, logs, and so on. ã   Microsoft® Windows® 2003 Enterprise Edition operating system—The database servers,benchmark servers, and storage management server all ran on Windows 2003 EE. 4
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