Published on February 27, 2014
WHY SHOULD I USE OVM For Oracle Databases By Francisco Munoz Alvarez – Oracle Professional Services Manager
Francisco Munoz Alvarez Some Certifications • • • Highlights • • • 8/9i/10g/11g OCP, RAC OCE, AS OCA, EBusiness OCP , SQL /PLSQL OCA , OVM Implementation Specialist, Oracle 7 OCM ITIL Certified Oracle 7 , Oracle 11gR2 and OVM 3.1 and 3.2 Beta Tester Blog: http://oraclenz.wordpress.com Twitter: fcomunoz Current Positions • • • • • • Oracle ACE Director NZOUG President LAOUC President CLOUG President IOUC LA Spokesperson Revera – Oracle Professional Services Manager
TODAY’S AGENDA Why use Virtualisation OVM Overview Benchmarks Conclusion Why Revera Questions
BEFORE START REVERA is a IaaS leader provider in NZ with many different options and solutions available to fulfil any type of requirement. The results on this presentation makes only reference regarding Oracle Database performance when running on a virtual environment.
WHY USE VIRTUALISATION Consolidation of workload Hardware independence Enhanced high availability & DR options Better utilisation of overall CPU & RAM, ability to redistribute Overall significantly better value and better utilisation of resources
WHAT IS OVM Oracle VM is an enterprise-proven server virtualization solution comprised of Oracle VM Server for x86, Oracle VM Server for SPARC and Oracle VM Manager that is scalable, and a low-cost server virtualization solution for both Oracle and non-Oracle workloads that makes enterprise applications easier to deploy, manage, and support.
WHAT IS OVM (Cont) Because OVM is build by Oracle all Oracle products deployed in Oracle VM such as the Oracle Database, Oracle Fusion Middleware, Oracle Applications, and Oracle Real Application Clusters and many others are fully supported and certified. OVM helps customers improve server utilization, achieve higher availability and achieve better performance while reducing costs.
THE ARCHITECTURE OVM Server – Based on the underlying Xen hypervisor technology – Management Linux Kernel with support of Devices (JeOS) – IO, Networking, etc VM – Guest OS with applications running on domU
MORE VALUE Key Benefits – – – – – – – – – – – – Application Aware Virtualization High Available and Scalable Easy and Efficient Centralized Management Fast Deployment and Standardization Application Driven Virtualization Soft and Hard Partitioning Support for Leading Enterprise Operation Systems Dynamic Resource Scheduling Integration with OEM12c Build by Oracle to Oracle and non-Oracle environments Only x86 server virtualization solution fully certified by Oracle and can be used with all Oracle Software Single Vendor Support, One call to Oracle; no finger pointing at another vendor
BENCHMARK Environment Preparation
SOME NOTES ON THE TESTING Performed in a lab environment, not on our actual Prod environment The trends are representative, but the numbers reflect the lab gear available at the time When we build VM service offerings they are tuned for general purpose IaaS workloads & use cases most common across customers We can tune for specific use cases, as this presentations will show
THE ENVIRONMENT Hardware – 3 DELL M610 with 96 GB RAM and 2 hexa-core processors each – OS: OEL 5.7 64 bit – Hitachi Storage (Fiber Channel Storage Array) Database – OEE 18.104.22.168 – SGA: 4864 MB – Redo: 7 Groups of 150 MB each
THE SERVERS VM’s – 4 vCPU’s each – 6 GB RAM each Virtualization Software – OVM 22.214.171.1246 – Other Hypervisors Bare metal – 12 CPU’s – 96 GB RAM
BENCHMARK PRODUCTS CPUmonitor 2.91 Swingbench 2.4
SETUP OF ENVIRONMENT
BENCHMARK The Results
RESPONSE TIMES Max and AVG Response Times (milliseconds)
Response Times Max and AVG Response Times (milliseconds)
Response Times AVG Response Times (milliseconds)
RESPONSE TIMES AVG Response Times (milliseconds)
TRANSACTIONS PER MINUTE AVG Transactions per minute
CPU WITH 200 SESSIONS
CPU WITH 400 SESSIONS
CPU WITH 800 SESSIONS
CPU WITH 800 SESSIONS
BENCHMARK/SCALING What happen if we give more resources to the VM?
WHEN SCALING • Increasing VM resources on-demand when achieving 400 concurrent sessions • RAM from 6GB to 12 GB • vCPUs from 4 to 8 Now let’s see what’s happen when giving more resources to the VM
Response Times AVG Response Times (milliseconds) 40 900 35 800 35 30 700 812 30 29 30 29 27 600 25 500 20 400 15 18 15 15 15 15 300 10 200 5 100 00 12 18 35 1 15 29 15 27 15 15 Users 15 Users 5050 Users Users 100 Users 100 Users 200200 Users Users Response Time AVG BM Response Time AVG BM 30 27 30 400 Users 400 Users Response Time AVG OVM Response Time AVG OVM 29 800 UsersUsers 800
TRANSACTIONS PER MINUTE AVG Transactions per minute 35000 30621 30000 30621 29523 25000 21854 20000 21685 21685 19604 15000 10881 10000 10924 5569 5000 0 838 838 810 2755 2755 2722 2722 5476 12541 10881 10924 5569 5476 810 50 1515 Users Users 50 Users Users100 Users 100 Users 200 Users 200 400 Users 400 Users 800 Users Transactions/min AVG BM Transactions/min AVG BM Transactions/min AVG OVM AVG OVM Transactions/min 800 Users
CPU WITH 400 SESSIONS (2)
CPU WITH 800 SESSIONS (2)
WHEN SCALING As you can see, without OVM you will have a full physical server with underutilized resources, but if using OVM, you will be able to virtualize it to host many Oracle DBs without loss of performance and making an efficient use of available licenses.
OTHER INFO • MANAGEMENT OF SGA MEMORY • SGA of 4864 MB • BM able to open 563 connections • Other Hypervisors able to open 523 connections • OVM able to open 567 connections
MYTHS or TRUE • • • • • It is not safe to run Production Environments on OVM If using OVM your database will run slower Oracle do not support production DB on OVM OVM is more expensive than other Hypervisors Other Hypervisors run Oracle Database faster than OVM
CONCLUSION • • • • • Oracle Database performs better at OVM OVM makes a better use of available resources OVM is more scalable and stable for Oracle DBs OVM allows better consolidation of loads in a virtual environment PLUS OVM uses less CPU than other Hypervisors a bonus: Allow licensing savings, extra HA and is fully certified and supported by Oracle.
BE CAREFUL What happen if you do not really know about OVM
P2V Normal Performance after P2V TPS MAX TPS AVG TPM MAX TPM AVG RT MAX RT AVG TTC RIPS DGPS (MB) Baremetal 27 14 924 810 277 35 53:32.0 45,161 3.40 OVM 21 13 866 719 1526 111 1:30:47 51,441 3.80
PARAVIRTUALIZED VMs Normal Performance of Paravirtualized VMs: TPS MAX TPS AVG TPM MAX TPM AVG RT MAX RT AVG TTC RIPS DGPS (MB) Baremetal 27 14 924 810 277 35 53:32.0 45,161 3.40 OVM 25 14 921 816 837 44 35:02.3 81,953 6.10
REVERA VMs Normal Performance of Revera VMs: TPS MAX TPS AVG TPM MAX TPM AVG RT MAX RT AVG TTC RIPS DGPS (MB) Baremetal OVM (Revera) 27 25 14 18 924 933 810 838 277 164 35 18 53:32.0 31:52.0 45,161 93,542 3.40 7.00 TPS MAX TPS AVG TPM MAX TPM AVG RT MAX RT AVG TTC RIPS DGPS (MB) OVM (PV) OVM (Revera) 25 25 14 18 921 933 816 838 837 164 44 18 35:02.3 31:52.0 81,953 93,542 6.10 7.00
WHY REVERA Over 2.0 Pb of storage and 2,500 VMs in operation 150 staff across four locations 5 data centers (small but perfectly formed) CommVault’s biggest NZ customer VMware Premier VSPP in NZ Hitachi Data Systems biggest NZ customer Oracle Platinum Partner Biggest OVM farm in NZ Dozens of templates customized to achieve the best performance and stability Scalable Environment The only OVM specialized partner in NZ Constantly investing in Research
SELECTION OF UTILITY COMPUTE OPTIONS Targeted at different use cases All Utility Pricing scale up-scale down Different Service Offerings focused at different use cases Customers consume based on SLAs and capabilities, not brand of hypervisor
THE PERFECT DUO
Thank You Any Questions?
WHY USE OVM FOR ORACLE DATABASES ... Revera is a partner of Oracle and manages the ... Built using OVM 126.96.36.1996 and hosts a unique guest VM that ...
WHY SHOULD I USE OVM For Oracle Databases ... Server for SPARC and Oracle VM Manager that is scalable, ... WHY REVERA Oracle Platinum Partner
Exadata, Exalogic, Oracle VM, sun ZFS, Oracle Databases ... Why Use Oracle VM for Oracle Databases? ... 225 Views. xKinAnx. Presentation best practices for ...
Learn how Oracle VM simplifies IT and makes your life easier. ... Find out why traditional virtualization is no longer enough. 1. Table of Contents.
LANDesk® Management Suite 8.7 Creating Database Links for Rolling Oracle* Databases to Oracle Databases Revision 1.0 Roy Meyer Mar. 7, 2007 The ...
Biografía de los oradores ... Why use OVM for Oracle Database. ... What strategies does one use in dealing with databases?
Oracle Vm at a glance: 10,296 LinkedIn members have this skill. Where they work. ... Oracle India Pvt. Ltd (35 members) Tata Consultancy Services (33 members)
Share BC-BRI BACKINT Interface for Oracle Databases. Embed ...