Search

Top 60 Oracle Blogs

Recent comments

SLOB Use Cases By Industry Vendors. Learn SLOB, Speak The Experts’ Language.

For general SLOB information, please visit: https://kevinclosson.net/slob.

Introduction

This is just a quick blog entry to showcase a few of the publications from IT vendors showcasing SLOB. SLOB allows performance engineers to speak in short sentences. As I’ve pointed out before, SLOB is not used to test how well Oracle handles transaction. If you are worried that Oracle cannot handle transactions then you have bigger problems than what can be tested with SLOB. SLOB is how you test whether–or how well–a platform can satisfy SQL-driven database physical I/O.

SLOB testing is not at all like using a transactional test kit (e.g., TPC-C). Transactional test kits are, first and foremost, Oracle intrinsic code testing kits (the code of the server itself). Here again I say if you are questioning (testing) Oracle transaction layer code then something is really wrong. Sure, transactional kits involve physical I/O but the ratio of CPU utilization to physical I/O is generally not conducive to testing even mid-range modern storage without massive compute capability. This is where vendors and dutiful systems experts rely on SLOB.

Recent SLOB testing on top-bin Broadwell Xeons (E5-2699v4) show that each core is able to drive over 50,000 physical read IOPS (db file sequential read).  On the contrary 50,000 IOPS is about what one would expect from over a dozen of such cores with a transactional test kit because the CPU is being used to execute Oracle intrinsic transaction code paths and, indeed, some sundry I/O.

SLOB Use Cases By IT Vendors

The following are links and screenshots from the likes of FlashGrid, Red Hat, DellEMC, HPE, Nutanix, NetApp, Pure Storage, IBM, Nimble Storage showing some of their SLOB use cases. Generally speaking, if you are shopping for modern storage–optimized for Oracle Database–you should expect to see SLOB results.

FlashGrid

The first case I’d like to share is that of a solution built by FlashGrid. This solution is all about using AWS EC2 instances, along with FlashGrid technology and best practices for Real Application Clusters,  in the AWS Cloud. I am not an expert on Flash Grid and am merely reporting their usage of SLOB as can be seen in the following paper and blog post:

I do recommend getting a copy of this paper!

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=500&h=313" alt="" width="500" height="313" srcset="https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=500&h=313 500w, https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=10... 1000w, https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=15... 150w, https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=30... 300w, https://kevinclosson.files.wordpress.com/2017/02/flashgrid-slob.png?w=76... 768w" sizes="(max-width: 500px) 100vw, 500px" />

FlashGrid Characterizing Real Application Clusters Performance with SLOB in the AWS Cloud (EC2 instances)

VMware

VMware showcasing VSAN with Oracle using SLOB at: https://blogs.vmware.com/apps/2016/08/oracle-12c-oltp-dss-workloads-flash-virtual-san-6-2.html.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-11-48-06-am.png?w=500&h=287" alt="screen-shot-2017-02-10-at-11-48-06-am" width="500" height="287" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-11-48-06-am.png?w=500&h=287 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 988w" sizes="(max-width: 500px) 100vw, 500px" />

VMware Using SLOB to Assess VSAN Suitability for Oracle Database

VMware has an additional publication showing SLOB results at the following URL: https://blogs.vmware.com/virtualblocks/2016/08/22/oracle-12c-oltp-dss-workloads-flash-virtual-san-6-2/

VCE

The VCE Solution guide for consolidating databases includes proof points based on SLOB testing at the following link: http://www.vce.com/asset/documents/oracle-sap-sql-on-vblock-540-solutions-guide.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-4-57-10-pm.png?w=500&h=161" alt="screen-shot-2017-02-10-at-4-57-10-pm" width="500" height="161" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-4-57-10-pm.png?w=500&h=161 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

VCE Solution Guide Using SLOB Proof Points

Nutanix

Next is Nutanix with this publication: https://next.nutanix.com/t5/Server-Virtualization/Oracle-SLOB-Performance-on-Nutanix-All-Flash-Cluster/m-p/12997

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-11-50-33-am.png?w=500&h=327" alt="Figure 2: Nutanix Using SLOB for Platform Suitability Testing" width="500" height="327" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-11-50-33-am.png?w=500&h=327 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 996w" sizes="(max-width: 500px) 100vw, 500px" />

Nutanix Using SLOB for Platform Suitability Testing

NetApp

NetApp has a lot of articles showcasing SLOB results. The first is at the following link: https://www.netapp.com/us/media/nva-0012-design.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-08-22-pm.png?w=500&h=235" alt="screen-shot-2017-02-10-at-12-08-22-pm" width="500" height="235" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-08-22-pm.png?w=500&h=235 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

NetApp Testing FlexPod Select for High-Performance Oracle RAC with SLOB

The next NetApp article entitled NetApp AFF8080 EX Performance and Server Consolidation with Oracle Database also features SLOB results and can be found here: https://www.netapp.com/us/media/tr-4415.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-01-52-pm.png?w=500&h=206" alt="Figure 4: NetApp Testing the AFF8080 with SLOB" width="500" height="206" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-01-52-pm.png?w=500&h=206 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 998w" sizes="(max-width: 500px) 100vw, 500px" />

NetApp Testing the AFF8080 with SLOB

Yet another SLOB-related NetApp article entitled Oracle Performance Using NetApp Private Storage for SoftLayer can be found here:  http://www.netapp.com/us/media/tr-4373.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-04-50-pm.png?w=500&h=213" alt="Figure 5: NetApp Testing NetApp Private Storage for SoftLayer with SLOB" width="500" height="213" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-04-50-pm.png?w=500&h=213 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

NetApp Testing NetApp Private Storage for SoftLayer with SLOB

When searching the NetApp main webpage I find 11 articles that offer SLOB testing results:

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/netappslob.png?w=500&h=271" alt="netappslob" width="500" height="271" srcset="https://kevinclosson.files.wordpress.com/2017/02/netappslob.png?w=500&h=271 500w, https://kevinclosson.files.wordpress.com/2017/02/netappslob.png?w=150&h=81 150w, https://kevinclosson.files.wordpress.com/2017/02/netappslob.png?w=300&h=162 300w, https://kevinclosson.files.wordpress.com/2017/02/netappslob.png?w=768&h=416 768w, https://kevinclosson.files.wordpress.com/2017/02/netappslob.png 975w" sizes="(max-width: 500px) 100vw, 500px" />

Searching NetApp Website shows 11 SLOB-Related Articles

HPE

Hewlett-Packard Enterprise offers an article entitled HPE 3PAR All-Flash Acceleration for Oracle ASM Preferred Reads which models performance using SLOB. The article can be found here: http://h20195.www2.hpe.com/V2/getpdf.aspx/4AA6-3375ENW.pdf?ver=1.0

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-13-56-pm.png?w=500&h=154" alt="screen-shot-2017-02-10-at-12-13-56-pm" width="500" height="154" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-13-56-pm.png?w=500&h=154 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

HPE Using SLOB For Performance Assessment of 3PAR Storage

Pure Storage

In the Pure Storage article called Pure Storage Reference Architecture for Oracle Databases, the authors also show SLOB results. The article can be found here:

https://support.purestorage.com/@api/deki/files/1732/=Pure_Storage_Oracle_DB_Reference_Architecture.pdf?revision=2.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-22-24-pm.png?w=500&h=157" alt="screen-shot-2017-02-10-at-12-22-24-pm" width="500" height="157" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-22-24-pm.png?w=500&h=157 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 998w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Pure Storage Featuring SLOB Results in Reference Architecture

Nimble Storage

Nimble Storage offers the following blog post with SLOB testing results: https://connect.nimblestorage.com/people/tdau/blog/2013/08/14.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-25-03-pm.png?w=500&h=197" alt="Figure 9: Nimble Storage Blogging About Testing Their Array with SLOB" width="500" height="197" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-25-03-pm.png?w=500&h=197 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Nimble Storage Blogging About Testing Their Array with SLOB

IBM

There is an IBM “8-bar logo” presentation showing SLOB results here:  http://coug.ab.ca/wp-content/uploads/2014/02/Accelerating-Applications-with-IBM-FlashJAN14-v2.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-28-45-pm.png?w=500&h=298" alt="screen-shot-2017-02-10-at-12-28-45-pm" width="500" height="298" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-28-45-pm.png?w=500&h=298 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

IBM Material Showing SLOB Testing

Kernel.org

I also find it interesting that folks contributing code to the Linux Kernel include SLOB results showing value of their contributions such as here: http://lkml.iu.edu/hypermail/linux/kernel/1302.2/01524.html.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-32-27-pm.png?w=500&h=126" alt="screen-shot-2017-02-10-at-12-32-27-pm" width="500" height="126" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-32-27-pm.png?w=500&h=126 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 641w" sizes="(max-width: 500px) 100vw, 500px" />

Linux Kernel Contributors Use SLOB Testing of Their Submissions

Red Hat

Next we see Red Hat disclosing Live Migration capabilities that involve SLOB workloads: https://www.linux-kvm.org/images/6/66/2012-forum-live-migration.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-35-23-pm.png?w=500&h=301" alt="screen-shot-2017-02-10-at-12-35-23-pm" width="500" height="301" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-35-23-pm.png?w=500&h=301 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Red Hat Showcasing Live Migration with SLOB Workload

Dell EMC

DellEMC has many publications showcasing SLOB results. This reference, however, merely suggests the best-practice of involving SLOB testing before going into production:

http://en.community.dell.com/techcenter/extras/m/white_papers/20438214.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-39-47-pm.png?w=500&h=391" alt="screen-shot-2017-02-10-at-12-39-47-pm" width="500" height="391" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-39-47-pm.png?w=500&h=391 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

DellEMC Advocate Pre-Production Testing with SLOB

An example of a detailed DellEMC publication showing SLOB results is the article entitled VMAX ALL FLASH AND VMAX3 ISCSI DEPLOYMENT GUIDE FOR ORACLE DATABASES which can be found here:

https://www.emc.com/collateral/white-papers/h15132-vmax-all-flash-vmax3-iscsi-deploy-guide-oracle-wp.pdf.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-47-19-pm.png?w=500&h=165" alt="screen-shot-2017-02-10-at-12-47-19-pm" width="500" height="165" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-47-19-pm.png?w=500&h=165 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

EMC Testing VMAX3 All-FLASH with SLOB

Another usage of SLOB by Dell EMC can be found at the following link: http://www.principledtechnologies.com/Dell/VMAX_250F_PowerEdge_R930_Oracle_perf_0417_v3.pdf. This paper is a partner effort with Principled Technologies and it showcases a VMAX 250F All-Flash Array performance characterization with SLOB.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=500&h=165" alt="" width="500" height="165" srcset="https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=500&h=165 500w, https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=1000&h=330 1000w, https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=150&h=49 150w, https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=300&h=99 300w, https://kevinclosson.files.wordpress.com/2017/02/250f-slob.png?w=768&h=253 768w" sizes="(max-width: 500px) 100vw, 500px" />

Dell EMC Partnering with Principled Technologies: SLOB Testing with VMAX 250F All-Flash

I took a moment to search the main DellEMC website for articles containing the word SLOB and found 76 such articles!

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-49-23-pm.png?w=500&h=363" alt="screen-shot-2017-02-10-at-12-49-23-pm" width="500" height="363" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-at-12-49-23-pm.png?w=500&h=363 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-10-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Search for SLOB Material on DellEMC Main Web Page

Red Stack Tech

Red Stack Tech offer DBaaS and even showcase the ability to test the platform for I/O suitability with SLOB:

http://www.redstk.com/services/cloud-technology-poc/

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-at-8-03-49-am.png?w=500&h=263" alt="screen-shot-2017-02-14-at-8-03-49-am" width="500" height="263" srcset="https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-at-8-03-49-am.png?w=500&h=263 500w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-... 1000w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-... 150w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-... 300w, https://kevinclosson.files.wordpress.com/2017/02/screen-shot-2017-02-14-... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Red Stack Tech Offering SLOB Testing as Proof of Concept

Non-Vendor References

Although not a vendor, it deserves mention that Greg Shultz of Server StorageIO and UnlimitedIO LLC lists SLOB alongside other platform and I/O testing toolkits. Greg’s exhaustive list can be found here: http://storageioblog.com/server-and-storage-io-benchmarking-resources/.

#000000;" src="https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=500&h=267" alt="storageio" width="500" height="267" srcset="https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=500&h=267 500w, https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=1000&h=534 1000w, https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=150&h=80 150w, https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=300&h=160 300w, https://kevinclosson.files.wordpress.com/2017/02/storageio.jpg?w=768&h=410 768w" sizes="(max-width: 500px) 100vw, 500px" />

 

Summary

More and more people are using SLOB. If you are into Oracle Database platform performance I think you should join the club! Maybe you’ll even take interest in joining the Twitter SLOB list: https://twitter.com/kevinclosson/lists/slob-community.

Get SLOB, use SLOB!

 

 

 

 

Filed under: oracle