White paper, Oracle oltp workloads, Summary and conclusion – QLogic 2600 Series 16Gb Gen 5 Fibre Channel for Database and Business Analytics User Manual
Page 4: Figure 3. throughput performance comparison

SN0430953-00 rev. a 07/13
4
White PaPer
QLogic 16Gb Gen 5 Fibre Channel vs. QLogic 8Gb
Fibre Channel
One of the key comparisons between 16Gb and 8Gb Fibre Channel is the
difference in performance. the following charts show the performance
improvements provided by the QLogic 2600 Series 16Gb Gen 5 Fibre
Channel adapter.
in Figure 3, throughput limiting is shown by the flat spots on the
graph, but there is the potential for additional performance beyond
the capability of the adapter. the 8Gb Fibre Channel results show this
limited throughput in several places, which extends the time required to
complete the task. On the other hand, specific queries of the workload in
the 16Gb environment completed up to 82 percent faster compared to the
8Gb environment. as shown in Figure 4, the total time to complete a
workload is noticeably less using the 16Gb Gen 5 Fibre Channel adapter.
0
200
400
600
800
1000
1200
1400
1600
1800
M
Bps
Workload Duration (seconds)
TPC-H MBps per Adapter
8GB SQL RAM
QLE2670
QLE2562
Figure 3. Throughput Performance Comparison
0
120
240
360
480
600
720
QLE2670
QLE2560
Se
co
nds
Total Time to Execute
QLogic 16Gb versus 8Gb
8Gb
16Gb
35%
Faster
Figure 4. Total Time to Execute is Faster Using 16Gb Gen 5 Fibre Channel
16Gb Gen 5 Fibre Channel provides additional bandwidth that can be used
by mission-critical database applications to improve performance over 8Gb
Fibre Channel. it also supports other i/O-intensive applications, such as
increased numbers of VMs running on physical servers, cloud applications,
and more.
in addition, the deployment of 16Gb Gen 5 Fibre Channel provides the
opportunity to reduce the number of cables required within server
racks. it can also play a role in consolidating the total number of Fibre
Channel Switch ports required in a SaN, because of the increased
bandwidth available.
Oracle OLTP Workloads
OLtP applications are highly transactional, and insert and update intensive.
this workload is typical for companies that have large transaction
processing applications, such as airline ticketing, large order-entry,
and banking applications. to make the benchmarks relevant to today’s
businesses, QLogic selected the market-leading Oracle relational Database
Management System (rDBMS), running on rheL
®
5.8 and simulated using
the Oracle-supplied OriON benchmark tool.
Figure 5 shows the two-fold performance advantage of QLogic 16Gb Fibre
Channel adapters over QLogic 8Gb Fibre Channel adapters in the OLtP
application environment.
0
50,000
100,000
150,000
200,000
250,000
300,000
350,000
400,000
450,000
1
2
3
4
5
6
7
8
16
24
32
40
48
56
64
72
80
88
96 104
IO
PS (
Tr
an
sa
ct
io
ns
/Se
co
nd
)
Outstanding I/Os (Increasing Workload) -------->
Oracle Database
OLTP Workloads
QLogic 16Gb (QLE2672)
QLogic 8Gb (QLE2562)
2X
IOPS
Figure 5. Oracle Database OLTP Performance Comparison
Summary and Conclusion
16Gb Fibre Channel infrastructure removes bottlenecks by providing
higher bandwidth capability for environments with growing performance
requirements, such as from virtualized servers, database applications, and
Solid State Drives.
true enterprise reliability is ensured by port-level isolation, which fully
segregates the Gen 5 Fibre Channel functions of each port on the adapter.
QLogic’s dual-port design has isolated the functionality for the processor,
memory, and firmware for each port on the adapter. the QLogic design
incorporates independent components, allowing activity such as high
i/O loads, resets, recoveries, and errors that occur on one port to not
impact the other port. each port on the QLogic host Bus adapter is able
to achieve full line-rate independent of the activity of the other port, unlike
competitive offerings.