Blog

Maximize your Oracle database performance with Cisco UCS X-Series

Oracle is the leading choice for many enterprise database applications. This includes not only the Oracle E-Business Suite, but applications like SAP, Siebel CRM and JD Edwards EnterpriseOne among others. Its power and scalability make it attractive for implementing business-critical applications. Having a high performing server infrastructure is critical for processing data and a good user experience.

UCS servers are an ideal choice for your Oracle workloads, and we’ve published a number of CVDs and white papers to help you get the most out of our solutions. Today, we are going to focus on the advantages of UCS X-Series.

NVMe storage

IOPS, or input/output operations per second, is the standard unit of measurement for the maximum number of reads and writes for storage performance. Think of updating a database each night for all the transactions that occurred during the day. The faster the database can read and write the shorter the system update will be each night. Databases love IOPS. No storage medium gives you more IOPS than NVMe. A high-performance SATA SSD will provide ~550MBps read/write speed. PCIe Gen 4 NVMe drive can reach 7,300 MBps read and 5,200MBps write speeds. The other benefit of NVMe drives is their low and consistent latency. X-Series supports up to six 15.3TB NMVe drives providing over 90TB of raw storage. If you want detailed information on X-Series and NVMe performance, check out this white paper.

100G Unified Fabric

All the storage capabilities can go to waste if the server doesn’t have a fast network to move the data on and off the server. Database transactions tend to work one of two ways. Server to server where lots of data can be transferred. Or server to client to what the client sends is small, but the database can return a lot of data. Both need a high-performance network for optimal results. And don’t forget you need to backup all that data! That’s where the 15000 Series VICs, 100G Intelligent Fabric Module, and 6536 Fabric Interconnect come into play. The three combine to provide 100G end-to-end connectivity – server, chassis, switch. Two future blog posts will go more in-depth on network performance and the 1.6TB/s possible for a X9508 Chassis.

Why does this matter?

Oracle is one of the most popular workloads that runs on Cisco UCS and our Converged Infrastructure solutions such as FlexPod and FlashStack. Older versions of Oracle Database are going out of extend support. Now is the time to refresh your Oracle environment to 19c or 21c.

In the video below, Sr. Product Manager John McAbel shows the outstanding performance of UCS X-Series with Oracle using the Swingbench load generator / benchmark tool. Swingbench is an industry standard tool that lets customers compare various Oracle solutions for performance and make an informed decision if it will work for them. Don’t worry about coping the link to the white paper at the end of the video, I have it down below in the resources section.

Anyone considering running Oracle Database on local disks typically looks at performance and protection against disk failures. In our recently published white paper, we demonstrated data protection using Oracle ASM based mirroring and NVMe hot plug capability. Oracle ASM mirrors data so that database and Oracle transactions continues to run even when disk fails. The disk can be quickly replaced.

What’s next 

Come back next week to read about how easy it is to achieve great performance out of the box.

 

Resources 

Deploy a High-Performance Standalone Oracle Database Solution: Oracle 19c on Cisco UCS X-Series white paper
Cisco UCS X-Series web page
All Cisco Validated Designs (CVD) for Oracle
Coming soon – FlashStack Hybrid Cloud Oracle 21c CVD
Coming soon – FlexPod X-Series 100G Oracle 21c CVD
Oracle Applications on Cisco UCS web page
All Cisco UCS X-Series resources
Cisco Intersight
Request a 1:1 Cisco Intersight demo
All X-Series blogs

X-Series video blog # 1 – Server deployment done right – Cisco UCS X-Series with Intersight
X-Series video blog # 2 – VDI to GPU Accelerated VDI – Cisco UCS X-Series with X-Fabric Technology
X-Series video blog # 3 – Automation with UCS X-Series leveraging Cisco Intersight and Ansible
X-Series video blog # 4 – Easily deploy your hybrid cloud apps with UCS X-Series and deploying Red Hat OpenShift Container Platform

No Comments

Leave a Reply

What’s New in Microsoft Teams for Education | September 2022What’s new and what’s next for SharePoint Server

Contact Us

We are always here to help. Please reach out to us and we'll get back to you as soon as possible.

Address:

Maruti Court, Ground Floor
Mvuli Road, Nairobi, Kenya

Contacts:

+254716973110

office@digitalexperts.co.ke

Hours:

Mon-Fri 8am – 5pm
Sat 9am – 1am
Sun & Holidays Closed