You are looking to size a data warehouse configuration. If the I/O throughput for the CPUs is 25
GB/s, the I/O throughput for the HBA is 18 GB/s, and the I/O throughput for the disk subsystem is
6 GB/s, what is the overall throughput of the data warehouse?
A.
25 GB/s
B.
18 GB/s
C.
6 GB/s
D.
It depends on how many processors are in the servers.
Explanation:
In this scenario the disk subsystem is the bottleneck. It determines the throughput.
Note: Each of the components must provide sufficient I/O bandwidth to ensure a well-balanced I/O
system.
The end-to-end I/O system consists of more components than just the CPUs and disks. A wellbalanced I/O system must provide approximately the same bandwidth across all components in
the I/O system. These components include:
* Host bus adapters (HBAs), the connectors between the server and the storage.
* Switches, in between the servers and a storage area network (SAN) or network attached storage
(NAS).
* Ethernet adapters for network connectivity (GigE NIC or Infiniband). In an Oracle Real
Application Clusters (Oracle RAC) environment, you need an additional private port for the
interconnect between the nodes that you should not include when sizing the system for I/O
throughput. The interconnect must be sized separately, taking into account factors such asinternode parallel execution.
* Wires that connect the individual components.
Reference: http://docs.oracle.com/cd/E11882_01/server.112/e10578/tdpdw_system.htm#autoId2