Qlogic 10000 Series Realize Significant Performance Gains User Manual download pdf

WHITE PAPER

Key Findings

• QLogic

recommends using the QLogic FabricCache™ 10000 Series Adapter in an Oracle

Real Application Cluster (RAC) database

with Oracle’s Automatic Storage Management (ASM) feature enabled and provisioning LUNs as a multiple of the quantity of nodes

in the RAC cluster. This configuration ensures distribution of the cache load over the QLogic 10000 Series Adapters in the cluster.

• Oracle recommends four LUNs for a disk group and, for best cache optimization, making the LUN quantity a multiple of the nodes.

• Each 10000 Series Adapter may cache up to 256 LUNs.

• All 10000 Series Adapters in the cluster must be zoned to be visible to each other.

• QLogic FabricCache 10000 Series Adapters enable:

– OLTP processing to be almost twice the transactions at 56 percent of the response time.

– OLAP processing to be 3.25 times the transactions at 25 percent of the response time.

Realize Significant Performance Gains

in Oracle RAC with QLogic FabricCache

Guide to Best Practices

1 2 3 4 5 6 7

WHITE PAPERKey Findings • QLogic® recommends using the QLogic FabricCache™ 10000 Series Adapter in an Oracle® Real Application Cluster (RAC) database

Page 2

SN0451405-00 Rev. B 07/13 2 WHITE PAPERConsiderations for Business Continuity, High Availability, and ScalabilityOracle RAC databases ensure tha

Page 3

SN0451405-00 Rev. B 07/13 3 WHITE PAPERcaching Fibre Channel Host Bus Adapters. In an Oracle RAC environment, Host Bus Adapters can be replaced

Page 4

SN0451405-00 Rev. B 07/13 4 WHITE PAPERData and IndexThe tablespaces that support the data and indexes are the largest tablespaces (use the most

Page 5

SN0451405-00 Rev. B 07/13 5 WHITE PAPER • The benefit of this shared cache becomes apparent when full table scans occur (Oracle does not cache t

Page 6

SN0451405-00 Rev. B 07/13 6 WHITE PAPERSummary and ConclusionsQLogic recommends using the QLogic 10000 Series Fibre Channel Adapter in an Oracle

Page 7

SN0451405-00 Rev. B 07/13 7 WHITE PAPERDisclaimerReasonable efforts have been made to ensure the validity and accuracy of these performance test

No comments

Qlogic 10000 Series Realize Significant Performance Gains User Manual