White paper – QLogic 2500 Series FC HBAs Accelerate Application Performance User Manual

Page 4

Advertising
background image

hSG-WP08005

PX2832001-00 rev. B 09/11

4

White PaPer

8Gb Oracle Advantages

to test the scalability of the QLogic 2500 Series 8Gb FC hBa, the
comparison between the 4Gb and 8Gb was tested using OLtP testing, Data
Warehousing, and Oracle Web applications. the tests demonstrate 8Gb
hBa functionality and its ability to scale to provide greater performance
supporting Oracle applications, in turn demonstrating the advantages of
8Gb SaNs.

OLtP applications are high throughput, insert/update-intensive. they are
typical for companies that have large transaction processing applications,
such as airline ticketing, large order-entry, and banking applications.
OLtP is the most common workload in the enterprise, so it provides
a good indication of the hBa’s scalability in a production setting. the
typical applications of Online analytical Processing (OLaP) are in business
reporting for sales, marketing, Business Performance Management (BPM),
budgeting and forecasting, financial reporting, and planning.

the following figure shows a 90 percent performance increase in OLaP
application performance using 8Gb over 4Gb.

OLAP Application Performance

Performance of the QLogic 2500 Series 8Gb FC hBa versus the QLogic
2400 Series 4Gb FC hBas was measured using the rate at which i/O
requests are serviced (iOPS). higher iOPS values denote greater throughput
and a higher level of performance.

Data Warehousing is critical to maintaining good data warehouse
performance with an increase in data volume and change, while maintaining
cost control. the QLogic 2500 Series 8Gb FC hBa provides for greater
throughput, providing an increase in the volume required. typically, 30
percent of the data kept in data warehouses is actively used. Maintaining
large amounts of inactive data in a data warehouse can significantly
compromise performance in terms of query processing and administrative
operations such as index reorganization, batch process execution, and

backups.the following figure shows a 100 percent increase from 4Gb to
8Gb supporting high throughput, insert/update-intensive workloads that
are typical for companies with large transaction processing applications.

Data Warehousing

Most database-backed Web applications have high throughput requirements
and are read-intensive, but not exclusively so. Web workloads mix a variety
of content and data-rich applications ranging from e-commerce and
banking applications to Customer relationship Management (CrM) and
self-service intranet applications. the following figure shows a 78 percent
increase from 4Gb to 8Gb supporting high throughput in support of Oracle
Web applications.

Oracle Web Applications

Advertising