QLogic 2500 Series 8Gb Fibre Channel Adapter of 8Gb Fibre Channel Adapter of Choice in Oracle Environments - Manual (Page 3)

hSG-WP08007 PX2832002-00 rev. D 03/13 3
White PaPer
a new class of server-side storage acceleration is the latest innovation
in the market addressing this performance disparity. the idea is simple:
fast, reliable, solid-state flash memory connected to the server brings
faster data access to the Oracle server’s CPU. Flash memory, in the form
of SSD media, is highly available in the market and promises to perform
much faster than any rotational disk under typical, small, highly random,
enterprise i/O workloads.
the QLogic 10000 Series Fibre Channel adapter provides i/O acceleration
to storage traffic for Oracle database servers. the QLogic 10000 Series
adapter is a PCie
® -based i/O device that provides the integrated storage
network connectivity, i/O caching technology, integrated SSD, and
embedded processing that are required to make SSD management and
caching tasks transparent to the host server. the QLogic solution delivers
the application performance acceleration benefits of transparent, server-
based cache, without the limitations of solutions that require separate,
server-based storage management software and OS filter drivers. as
a shared caching resource, QLogic FabricCache adapters introduce
server-based caching for virtualized and clustered environments, such
as Oracle real applications Clusters (raC), which up to now have been
precluded by the single server “captive” nature of existing server-based
caching solutions.
For optimal Oracle database performance, maximized i/O transaction rate
and minimized i/O latency indicate a peak-performing Oracle database
system. By optimizing these performance values, the platform can support
additional workloads, thereby reducing server, management, and overall
infrastructure costs. the key benefits of the QLogic 10000 Series adapter
identified in this paper are improvements for Oracle server performance
that reduce overall costs.
Test Setup
the test setup (shown in Figure 1) was configured with an intel ® Xeon ®
server connected to an hP ® enterprise Virtual array (eVa) storage array
through the QLogic QLe10000 adapter and QLogic 5800V/5802V Fibre
Channel Switch. Orion runs were executed with SSD cache levels varying
in size from zero to 100 percent of the actual database size. See appendix
B for actual configuration information.
Figure 1. Exchange Test Setup
Orion Test Results
Figure 2. Test Results: 13 × IOPS Performance over Non-Cached Operations
QLogic and Emulex 8Gb Standard Fibre Channel Adapter
Comparison
the tests described in this section of the paper analyzed and compared
the i/O performance of QLogic and emulex 8Gb Fibre Channel adapters
in a representative selection of database-driven workloads, such as the
following:
• An OLTP Workload. OLtP applications are high throughput, insert/
update-intensive. this workload is typical for companies that have large
transaction processing applications, such as airline ticketing, large
order-entry, and banking applications.
• An OLAP Workload. the purpose of an OLaP workload is to quickly
provide answers to analytical queries that are multidimensional and
part of the broader category of business intelligence. OLaP workloads
are typically used in relational reporting and data mining.
0
10000
20000
30000
40000
50000
60000
70000
7 28 56 84 112 140
IO
PS
# Outstanding Small I/O's
Orion IOPS for Small Random I/O's
0% cache 30% cache 70% cache 90% cache 100% cache
13x