Improve Oracle database performance in a flash

Christian Putz says moving databases from hard drives to flash can bring sizeable improvements in performance

Tags: DatabaseFlash drivesOracle CorporationPure Storage (www.purestorage.com)
  • E-Mail
Improve Oracle database performance in a flash All-Flash storage for databases offers a range of benefits, says Putz.
By  Christian Putz Published  April 6, 2016

Uptime and availability of applications are critical. Every moment of downtime can be extremely costly—in lost revenue, missed opportunities and customer goodwill. Therefore, it is important to deploy flash solutions that offer five nines reliability along with a resilient architecture that doesn’t tolerate even planned downtime.

Speed to market is another important differentiator. In today’s business environment, organizations need to be able to respond quickly to new opportunities and they can’t afford long development cycles. Flash storage gives LOB decision makers the opportunity to eliminate bottlenecks and get applications into the hands of users much faster.

What to look for in an all-flash solution

For DBAs and LOB managers, the specific challenges may differ but there are common goals as well: to get the performance they require from their Oracle databases; to deploy a solution that is resilient and reliable; to keep costs under control; to make their lives simpler; and to use technology that helps grow and scale the business. Here are some of the important considerations in evaluating all flash solutions.

Extreme performance:

Today’s all-flash solutions should be able to deliver consistently high performance at sub-millisecond latency.

Simple by design:

Enabling you to use any file system, block size or number of LUNs, with no issues around tuning, caching or tiering and with simple snapshots for recovery and development.

Highly efficient:

Using industry leading compression and deduplication technologies to significantly reduce the storage footprint.

Cost-effective:

The all-flash solution should enable you to reduce costs by optimising Oracle licensing through workload consolidation, while also lowering operating overhead and reducing requirements for server hardware, data center space, cooling and power.

Immunity from storage disruptions:

Features to look for include crash-consistent snapshots, RAID-3D dual parity and five nines availability.

Taking the next step

Moving Oracle databases to all-flash storage is a necessary and inevitable step. The performance gap between spinning disks is too great and the performance requirements of Oracle databases are too demanding for it to be any other way. As DBAs and LOB managers work with their IT storage and infrastructure teams to evaluate all-flash solutions, they need to be looking at products that address their requirements for performance, simplicity, cost efficiency, resiliency and high availability.

Christian Putz is director, emerging markets, Europe, Middle East & Africa, Pure Storage.

Add a Comment

Your display name This field is mandatory

Your e-mail address This field is mandatory (Your e-mail address won't be published)

Security code