Nutanix performance with oracle slob on all flash nodes _ long white virtual clouds

Kevin Closson’s Silly Little Oracle Benchmark, aka SLOB, is a great free tool to test the IO capability of an OLTP type system based on small 8KB IO, with varying IO patterns (update percentages). Data recovery laptop It uses the database engine to generate the IO, to provide an understanding of the possible IO capability of the platform, and what the database sees from the underlying infrastructure. Data recovery flash drive By using AWR reports you can measure the IO throughput and latency of the database after each test and use that as a comparison when making changes.


Data recovery cost The purpose of using SLOB is to test the underlying infrastructure, not to test the database software itself. Data recovery galaxy s5 This article will cover example SLOB and Guest OS configurations used to test two different versions of Nutanix AOS software in an all flash cluster. Database key field The only changes between the sets of tests was the Nutanix AOS software to demonstrate the difference in performance that may be achieved by a simple one click upgrade from AOS 4.7 to AOS 5.0. Data recovery nashville SLOB is used as it is an easy way to set up a repeatable and measurable test.

I had first written about using SLOB in my article All Flash Performance on Web Scale Infrastructure. Data recovery minneapolis The tests there were based on using a single 2 Node Oracle RAC Cluster to drive load, whereas the test I have done for this article are using multiple Oracle Database VM’s and scaling out across multiple servers. Database 4 net The sets of tests demonstrate the linearity of performance scaling available in the Nutanix platform, which is very predictable. Iphone 6 data recovery software free As you add more resources (nodes and VM’s), you get more performance.

• When using VMware, Virtual Disks (VMDK’s) should be split across 4 x PVSCSI Controllers, Hyper-V should use SCSI Controllers on Generation 2 VM’s and AHV is by default using SCSI directly to the guest OS

Each VM was installed with Oracle Grid Infrastructure 12.1.0.2 and Oracle database software 12.1.0.2. Database usa reviews Below is the initialization parameter was used for the SLOB database. Easeus data recovery 94fbr *._db_block_prefetch_limit = 0

The configuration parameters are standard as per the SLOB documentation and README files, but some settings are modified based on the type of test you want to run. Database join The following settings are in slob.conf.

I used 00, 30, 50, or 100 during various tests based on the percentage of updates required. H2 database download Note that using 100 as the update percent produces a roughly 50% random write workload. H2 database url The graphs below are with this set to 30

I used 1 or 2, 1 was used during most runs, I experimented with 2 with higher update percentages to drive more load. Data recovery boot disk The graphs below are from tests with this set to 1.

Now lets look at some results, which I have graphed for you. 990 database The first test is with 4 VM’s on 4 Nodes, followed by 8 VM’s on 8 Nodes. Data recovery hard drive cost This shows the increase in performance when scaling a configuration. Data recovery knoxville During the test all data reduction features are enabled. 7 data recovery keygen Data Checksums are always enabled and can’t be disabled, unlike some competing platforms. H2 database client All the VM’s and storage used in these tests take up just 4 rack units. Dayz database The SSD’s used in the All Flash Nutanix nodes are standard Intel S3610 SATA-SSD’s, no NVMe or anything exotic is used. I phone data recovery When NVMe platforms are available we will repeat the tests and share the results.

The only difference between the above tests was the version of Nutanix AOS software running on the cluster. Database 3d No hypervisor version upgrade is required between tests to achieve better performance. Yorku database Average read and log file write latency were fairly good and fairly linear. O o data recovery CPU utilization across the nodes was ~ 60% during the tests and more performance was available, so these test do not represent peak performance by any means. Data recovery illustrator Scaling up to 2 VM’s per node almost doubled IO performance, at the cost of some additional latency as workload increases. Database management software The hardware used during the test had the Intel Xeon v3 processors, which are Haswell, the latest generation is v4 Broadwell. Database normalization example If the same tests were repeated on Broadwell it would be expected to show approximately a 15% improvement in performance. Database virtualization Software defined storage benefits not only from software improvements but also improvements in system and CPU performance improvements. Data recovery machine Which means you can have continuing performance improvements at a much faster rate than on traditional infrastructures.

I decided to record similar images from my previous article from Oracle Enterprise Manager Express while testing against a 4 Node Oracle RAC cluster using SLOB, but this time a 100% read test (UPDATE_PCT=00). Data recovery cell phone Each RAC Node VM was configured with 24 vCPU and 32GB RAM. Data recovery wizard free The results were as follows:

Instead of using standard virtual disks with the Oracle RAC Nodes in these tests I used Nutanix Acropolis Block Services and in-guest iSCSI initiator to connect to 40 iSCSI LUN’s that are distributed and load balanced across the Nutanix cluster. Pokemon x database By doing this it allows a small number of VM’s, in this case 4 x Oracle RAC Nodes, to benefit from a larger number of storage controllers and therefore increased overall performance. Data recovery chicago There is a cost to latency however due to the partial loss of data locality for the transactions that need to go over the network. R studio data recovery full version Acropolis Block Services allows either VM’s or External Physical OS (Oracle Linux, Oracle VM, Windows and other Linux variants) to benefit from the Nutanix environment.

As with a lot of tests these were conducted in a controlled environment that isn’t subject to the random noise of a production environment, and while nothing else was consuming resources of the systems used in the test. Database wiki As a result your milage in real world environments will be different. Data recovery freeware However under the same conditions, with the same configuration, you should be able to reproduce the same or similar results. Database clustering There are more factors involved in selecting a platform than just performance. Icare data recovery These results compare very favorably to other published HCI SLOB results, especially on latency, which is significantly lower. Data recovery jacksonville fl I partnered with Mellanox on the switching hardware for this environment. 510 k database search Their switches produce predictable latency and performance across a variety of message sizes. Database engineer You can read more about Mellanox switching solutions for Nutanix environments here. Data recovery california For general performance information about Nutanix please see Raising the Bar and Pushing the Envelope on Performance.

This post first appeared on the Long White Virtual Clouds blog at longwhiteclouds.com. By Michael Webster +. Copyright © 2012 – 2016 – IT Solutions 2000 Ltd and Michael Webster +. Moto x data recovery All rights reserved. Database administrator Not to be reproduced for commercial purposes without written permission.

Posted in Business Critical Applications, Nutanix, VMware | Tagged AHV, All Flash, Nutanix, Oracle, Performance About the Author Michael Webster

Michael is Manager of Business Critical Applications Engineering at Nutanix. Database acid He has been using VMware products since 1998 and has been deploying ESX solutions since 2002. Database 10g He specializes in designing virtualization solutions for Unix to Linux migrations, business critical applications, disaster avoidance, and mergers and acquisitions. Database news Michael has been in the IT industry since 1995 and consulting since 2001. Database key value Michael is Nutanix Platform Expert (NPX) #007. Data recovery pro review In addition to VCDX he holds VCP, VCP-Cloud, VCAP-DCD, VCAP-DCA, VCAP-CID, VCAP-CIA, ITIL Foundation, MCP I, and MCSE (NT4 – 2K3).

Related Posts How to Performance Test 101 in 5 Steps → Disable Windows Disk Write Cache for Data Integrity and Better Performance → David vs Goliath or Daniel Hassling Oracle → VMware vRealize Management Packs for Nutanix → 11765One Response http%3A%2F%2Flongwhiteclouds.com%2F2016%2F12%2F31%2Fnutanix-performance-with-oracle-slob-on-all-flash-nodes%2F Nutanix+Performance+with+Oracle+SLOB+on+All+Flash+Nodes 2016-12-31+05%3A05%3A23 Michael+Webster http%3A%2F%2Flongwhiteclouds.com%2F%3Fp%3D11765

banner