Oracle Workloads – Where Eagles Dare !!!

Enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds

• Slow database Archivelog performance will considerably slow the database down resulting in breach of SLA’s.
• Slow database Backups will result in database backup’s spilling outside the production backup window resulting in disruption of database operations and breach of SLA’s as well.
• Non-production workloads e.g., Development, Test, QA, Staging, Functional, Pre-Production etc are equally important as the Production workloads, as they are key entities and instrumental to any Production workload success and adds to space demands with the ever-increasing database sizes.

The goal is to provide Comparable performance, Storage savings and meet the Business SLA’s by using VMware Cloud Flex Storage for Oracle Archivelogs, Oracle Backups and Oracle Non-Production workloads.

Summary of blogs

The first blog Providing Performance and Storage savings using VMware Cloud Flex Storage for Oracle Archivelogs  is an exercise to evaluate the feasibility and showcase the advantages of using VMware Cloud Flex Storage for business-critical Oracle workloads on VMware Cloud on AWS as a viable & comparable Storage option for Oracle Archivelog files destination.

The second blog Providing Storage savings and Comparable performance using VMware Cloud Flex Storage for Oracle Backups is an exercise to evaluate VMware Cloud Flex Storage as a viable & comparable Storage option for Oracle backups destination.

The third blog Providing Storage savings and Comparable performance using VMware Cloud Flex Storage for Oracle Non Production workloads is an exercise to evaluate VMware Cloud Flex Storage as a viable & comparable Storage option for Oracle non-production workloads.

This blog is not meant to be a performance benchmarking-oriented blog in any way.  Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing, so the performance improvement I got with my workload in my lab is in no way representative of any real production workload which means the performance improvements for real world workloads will be better.

Non-production workloads e.g. Development, Test, QA, Staging, Functional, Pre-Production etc are equally important as the Production workloads , as they are key entities and instrumental to any Production workload success.

Ensuring that Pre-Production databases are comparable in performance with the Production databases is key in ensuring that any performance related issues are identified well ahead in the process before they make it to the Production environment. In addition, ensuring that there is adequate testing and validation ensures due diligence is done with any software release.

Key points to take away from this blog

This blog is the third blog in the series of evaluating VMware Cloud Flex Storage as a viable & comparable Storage option for Oracle non-production workloads.

The first blog Providing Performance and Storage savings using VMware Cloud Flex Storage for Oracle Archivelogs  was an exercise to evaluate the feasibility and showcase the advantages of using VMware Cloud Flex Storage for business-critical Oracle workloads on VMware Cloud on AWS as a viable & comparable Storage option for Oracle Archivelog files destination.

The second blog Providing Storage savings and Comparable performance using VMware Cloud Flex Storage for Oracle Backups was an exercise to evaluate VMware Cloud Flex Storage as a viable & comparable Storage option for Oracle backups destination

This blog is not meant to be a performance benchmarking-oriented blog in any way.  Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing, so the performance improvement I got with my workload in my lab is in no way representative of any real production workload which means the performance improvements for real world workloads will be better.

You are as good as your last backup – DBA 101 – the ability to allow restore & recovery from an earlier point in time to allow business recover from unplanned event.

We are all aware that slow database Backups will result in database backup’s spilling outside the production backup window resulting in disruption of database operations and breach of SLA’s as well.

Key points to take away from this blog

This blog is the second blog in the series of evaluating VMware Cloud Flex Storage as a viable & comparable Storage option for Oracle backups destination.

The first blog Providing Performance and Storage savings using VMware Cloud Flex Storage for Oracle Archivelogs  was an exercise to evaluate the feasibility and showcase the advantages of using VMware Cloud Flex Storage for business-critical Oracle workloads on VMware Cloud on AWS as a viable & comparable Storage option for Oracle Archivelog files destination.

Offloading Archivelog files and Backup dumps to VMware Cloud Flex Storage results in

• Providing storage & comparable performance to Archivelog & Backup activities for the database
• Ensuring Tier-1 vSAN Internal NVMe storage is reserved for hot/warm database data for capacity and performance.

This blog is not meant to be a performance benchmarking-oriented blog in any way. Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing, so the performance improvement I got with my workload in my lab is in no way representative of any real production workload which means the performance improvements for real world workloads will be better.

Space: the final frontier – Oracle production workloads have stringent Storage & IO requirements with database Archivelog generation and database backup’s adding to performance and space demands with the ever-increasing database size.

Enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds

• Slow database Archivelog performance will considerably slow the database down resulting in breach of SLA’s.
• Slow database Backups will result in database backup’s spilling outside the production backup window resulting in disruption of database operations and breach of SLA’s as well.

Key points to take away from this blog

This blog is an exercise to evaluate the feasibility and showcase the advantages of using VMware Cloud Flex Storage for business-critical Oracle workloads on VMware Cloud on AWS as a viable & comparable Storage option for

• Oracle Archivelog files destination
• Oracle Backup dump destination

Offloading Archivelog files and Backup dumps to VMware Cloud Flex Storage results in

• Providing storage & comparable performance to Archivelog & Backup activities for the database
• Ensuring Tier-1 vSAN Internal NVMe storage is reserved for hot/warm database data for capacity and performance.

This blog is not meant to be a performance benchmarking-oriented blog in any way. Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing, so the performance improvement I got with my workload in my lab is in no way representative of any real production workload which means the performance improvements for real world workloads will be better.

Heads I win , Tail you gonna lose  – “Bon Jovi” !!!

Business Critical Oracle Workloads have stringent IO requirements and enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds

When it comes to Business-Critical Oracle Workloads, the critical requirement is consistent performance and that does not involve tossing a coin every time someone runs a workload to determine whether that would meet the business SLA’s or not!!!

Key points to take away from this blog

This blog is a preview of the changes VMware Engineering will be working on to report more appropriate values for ‘Optimal transfer length’ and ‘Maximum transfer length’ fields in Vital Product Data (VPD) page B0 response, for the underlying physical device, hosting the vmdk’s, to Guest OS for optimal IO performance for Business-Critical Workloads on VMware platform.

This will ensure VMware vSphere platform is more performant for customers to run their Business-Critical workloads and to meet customers stringent SLA’s.

This blog is not meant to be a performance benchmarking-oriented blog in any way.

Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing, so the performance improvement I got with my workload in my lab is in no way representative of any real production workload which means the performance improvements for real world workloads will be better.

Continue reading →

This blog is the second blog in the series of providing Business Continuity and Disaster Recovery to Oracle workloads on VMware Hybrid Multi-Clouds.

The first blog “Oracle Business Continuity and Disaster Recovery on VMware Hybrid Multi-Clouds” was released in 2021 and was the comprehensive reference architecture solution which described the configuration and implementation of various business continuity and disaster recovery options e.g. Native Oracle tools, VMware tools (SRM, vSphere Replication, Array based using VMFS/vVOLS, VSR , VCDR) across all 3 levels – Application, VMware platform, and Storage levels of both Oracle Single instance and Real Application Cluster (RAC) workloads on the VMware vSphere hybrid multi-cloud platform. This includes on-premises and VMware clouds, with an emphasis on VMware Cloud on AWS.

Key points to take away from this blog

This blog focusses primarily on use-case scenarios for providing Disaster Recovery for Oracle Single instance & Oracle RAC workloads, after being migrated / replatformed to VMware on-premises, with an aim of ultimately providing DR to VMware Hybrid Multi-Cloud from the below source platforms

• Big-endian systems (Solaris, AIX, HP-UX)
• Oracle Engineered Systems (e.g., Exadata, ODA etc)
• Physical commodity x86-64 servers
• non-VMware platform (OVM, LVM, KVM, Xen)

This blog is the second blog in the series of “Deploying Oracle Workloads on VMware vSphere 8.0 using NVMe/TCP backed Lightbits software” blogs.

The first blog “Deploying Oracle Workloads on VMware vSphere 8.0 using NVMe/TCP with Lightbits Scale out Disaggregated Storage” can be found here.

Business Critical Oracle Workloads have stringent IO requirements and enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds.

Oracle RAC provides high availability and scalability by having multiple instances access a single database which prevents the server from being a single point of failure. Oracle RAC enables you to combine smaller commodity servers into a cluster to create scalable environments that support mission critical business applications.

With increasing need for data to be “fast and furious”, customers are turning to NVMe transfer protocol for accessing data quickly from flash memory storage devices such as solid-state drives (SSDs).

NVMe, or nonvolatile memory express, is a storage access protocol and transport protocol for flash and next-generation solid-state drives (SSDs) that delivers high throughput and fast response times for a variety of traditional and modern workloads. While all-NVMe server-based storage has been available for years, the use of non-NVMe protocols for storage networking can add significant latency.

To address this performance bottleneck, NVMe over TCP or NVMe/TCP, extends NVMe’s performance and latency benefits across TCP based network fabric.

We’ve heard from our customers that they would like to run NVMe/TCP because:

• TCP/IP is ubiquitous
• Well understood – TCP is probably the most common transport
• High performance – TCP delivers excellent performance scalability
• Well suited for large scale deployments and longer distances
• Actively developed – maintenance and enhancements are developed by major players
• Inherently supports in-transit encryption

More information on NVMe/TCP Support with VMware vSphere 7 Update 3 can be found here.

More information on VMware NVMe Concepts can be found here.

Key points to take away from this blog

This blog is not meant to be a performance benchmarking-oriented blog.

This blog is meant to raise the awareness of the simplicity and seamless use of NVMe/TCP storage backed datastores provided by Lightbits Storage to provide vmdk based storage for business-critical Oracle RAC workloads.

Continue reading →

Business Critical Oracle Workloads have stringent IO requirements and enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds

With increasing need for data to be “fast and furious”, customers are turning to NVMe transfer protocol for accessing data quickly from flash memory storage devices such as solid-state drives (SSDs).

NVMe, or nonvolatile memory express, is a storage access protocol and transport protocol for flash and next-generation solid-state drives (SSDs) that delivers high throughput and fast response times for a variety of traditional and modern workloads. While all-NVMe server-based storage has been available for years, the use of non-NVMe protocols for storage networking can add significant latency.

To address this performance bottleneck, NVMe over TCP or NVMe/TCP, extends NVMe’s performance and latency benefits across TCP based network fabric.

We’ve heard from our customers that they would like to run NVMe/TCP because:

• TCP/IP is ubiquitous
• Well understood – TCP is probably the most common transport
• High performance – TCP delivers excellent performance scalability
• Well suited for large scale deployments and longer distances
• Actively developed – maintenance and enhancements are developed by major players
• Inherently supports in-transit encryption

More information on NVMe/TCP Support with VMware vSphere 7 Update 3 can be found here.

More information on VMware NVMe Concepts can be found here.

Key points to take away from this blog

This blog is not meant to be a performance benchmarking-oriented blog.

This blog is meant to raise the awareness of the simplicity and seamless use of NVMe/TCP storage backed datastores provided by Lightbits Storage to provide vmdk based storage for Oracle workloads.

Oracle workloads can take advantage of NVMe/TCP storage using VM vNVME controller backed vmdk’s on those NVMe/TCP storage enhancing performance with high throughput, low latency, fast response times and reduced CPU utilization.

From an Oracle workload or pretty much any Application on VMware platform, from a functional perspective, a vmdk carved form a NVMe/TCP backed Datastore is just a regular vmdk which then gets attached to the VM and gets consumed the same way as any regular vmdk on a VMFS /vVOL / NFS / vSAN datastore.

Continue reading →

Business Critical Oracle Workloads have stringent IO requirements and enabling, sustaining, and ensuring the highest possible performance along with continued application availability is a major goal for all mission critical Oracle applications to meet the demanding business SLA’s, all the way from on-premises to VMware Hybrid Clouds

Oracle RAC provides high availability and scalability by having multiple instances access a single database which prevents the server from being a single point of failure. Oracle RAC enables you to combine smaller commodity servers into a cluster to create scalable environments that support mission critical business applications.

Key points to take away from this blog

This blog showcases the validation of vMotion capability for Oracle RAC cluster on VMware vSphere Platform which can be achieved seamlessly without any issue, with appropriate settings in place

• with Change Block Tracking (CBT) enabled for non-shared disk
• with multi-writer attribute set for the shared vmdk’s

Continue reading →