h8029 Maximize Oracle Rac Symmetrix Fast VP Wp

Please download to get full document.

View again

of 37
12 views
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.

Download

Document Related
Document Description
symmetrix
Document Share
Document Tags
Document Transcript
   White Paper    EMC GLOBAL SOLUTIONS Abstract This white paper describes an automated storage tiering solution for Oracle RAC 11 g   databases residing on Symmetrix VMAX™ storage. EMC ®  Symmetrix ®  FAST VP automatically monitors and moves data between thin storage tiers at the sub-LUN level, placing the right data on the right tier at the right time, without user intervention. February 2011 MAXIMIZE OPERATIONAL EFFICIENCY FOR ORACLE RAC ENVIRONMENTS WITH EMC SYMMETRIX FAST VP (AUTOMATED TIERING) An Architectural Overview    2 Maximize Operational Efficiency for Oracle RAC Environments with EMC Symmetrix FAST VP (Automated Tiering)—An Architectural Overview Copyright © 2011 EMC Corporation. All Rights Reserved. EMC believes the information in this publication is accurate of its publication date. The information is subject to change without notice. The information in this publication is provided “as is.” EMC Corporation makes no representations or warranties of any kind with respect to the information in this publication, and specifically disclaims implied warranties of merchantability or fitness for a particular purpose. Use, copying, and distribution of any EMC software described in this publication requires an applicable software license. For the most up-to-date listing of EMC product names, see EMC Corporation Trademarks on EMC.com. VMware and ESX are registered trademarks or trademarks of VMware, Inc. in the United States and/or other jurisdictions. All other trademarks used herein are the property of their respective owners. Brocade may have substituted components of the srcinal environment in this document with hardware of a similar (or higher) specification to the srcinal equipment used in the EMC Proven Solution. The content contained in this document srcinated from a validated EMC Proven Solution. The modification introduced by Brocade may have caused changes in performance, functionality, or scalability of the srcinal solution. Please refer to www.EMC.com/solutions for further information on validated EMC Proven Solutions. Part Number: h8029    3 Maximize Operational Efficiency for Oracle RAC Environments with EMC Symmetrix FAST VP (Automated Tiering)—An Architectural Overview Table of Contents Executive summary .............................................................................................................. 5   Introduction to EMC Symmetrix VMAX with Enginuity 5875 ................................................. 5   Business case .................................................................................................................... 5   Solution overview ............................................................................................................... 6   Key results ......................................................................................................................... 7   Introduction ........................................................................................................................ 8   Purpose .............................................................................................................................. 8   Scope ................................................................................................................................. 8   Audience ............................................................................................................................ 8   Terminology ....................................................................................................................... 8   Key technology components .............................................................................................. 10   Overview .......................................................................................................................... 10   EMC Symmetrix VMAX with Enginuity 5875 ....................................................................... 10   EMC Symmetrix Management Console .............................................................................. 10   EMC Symmetrix Performance Analyzer .............................................................................. 10   EMC Virtual Provisioning .................................................................................................. 11   EMC Virtual LUN VP Mobility ............................................................................................. 11   EMC Symmetrix FAST VP ................................................................................................... 11   EMC PowerPath ................................................................................................................ 11   Oracle Database 11 g R2 Enterprise Edition ....................................................................... 11   Brocade infrastructure ...................................................................................................... 12   EMC Virtual Provisioning .................................................................................................... 13   Virtual Provisioning overview ............................................................................................ 13   Overprovisioning .............................................................................................................. 13   Monitoring and administering virtual pools ...................................................................... 14   Growing and rebalancing virtual pools .............................................................................. 15   EMC Symmetrix FAST VP .................................................................................................... 16   FAST VP overview .............................................................................................................. 16   FAST VP components ........................................................................................................ 16   FAST VP performance measurement and data movement ................................................. 17   FAST VP with an Oracle OLTP workload ............................................................................. 18   FAST VP with Oracle ASM striping ..................................................................................... 19   Solution architecture and design ....................................................................................... 20   Solution architecture ........................................................................................................ 20   Use case profile ................................................................................................................ 21   Hardware and software environment ................................................................................ 21   Database storage layout for thin devices .......................................................................... 22   Storage design considerations for Oracle ......................................................................... 22      4 Maximize Operational Efficiency for Oracle RAC Environments with EMC Symmetrix FAST VP (Automated Tiering)—An Architectural Overview Oracle database configuration ........................................................................................... 23   Database schemas ........................................................................................................... 23   Database services ............................................................................................................ 23   SOE tables and indexes .................................................................................................... 23   Configuring EMC Symmetrix FAST VP .................................................................................. 24   Overview of FAST VP configuration .................................................................................... 24   Step 1: Enable FAST controller and set control parameters ............................................... 24   Step 2: Create storage groups .......................................................................................... 25   Step 3: Create storage tiers .............................................................................................. 26   Step 4: Create FAST policies ............................................................................................. 26   Step 5: Associate storage groups with FAST policies ......................................................... 27   Step 6: Configure FAST VP monitoring and move windows ................................................ 28   Solution testing and validation .......................................................................................... 29   FAST VP versus manual tiering .......................................................................................... 29   FAST VP test procedure ..................................................................................................... 30   FAST VP rebalancing across tiers ...................................................................................... 31   FAST VP effects on database transactions per minute ....................................................... 32   FAST VP effects on Oracle service response time .............................................................. 32   FAST VP effects on average host IOPS ............................................................................... 33   Summary of FAST policy effects ........................................................................................ 33   Conclusion ........................................................................................................................ 35   Summary .......................................................................................................................... 35   Findings ........................................................................................................................... 35   References ........................................................................................................................ 37   White papers and technical notes .................................................................................... 37   Product documentation .................................................................................................... 37   Other documentation ....................................................................................................... 37  
Search Related
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