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

Advertising
background image

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.

Advertising