How to calculate IOPS in Exadata ?

When we think to calculate IOPS , it seems very difficult task but it’s very easy to calculate in Exadata Storage. Let’s understand the procedure to calculate IOPS.

Well, first of all, execute the calibrate command on all available cell storage.

We are doing testing on Exadata Database Machine X3-2 1/8^th rack. Same procedure can be followed on any configuration of Exadata.

Cell Server 1

CellCLI> calibrate force

Calibration will take a few minutes...

Aggregate random read throughput across all hard disk LUNs: 1521 MBPS

Aggregate random read throughput across all flash disk LUNs: 8048.46 MBPS

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2380

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 113116

Controller read throughput: 1974.08 MBPS

Calibrating hard disks (read only) ...

LUN 0_0  on drive [20:0     ] random read throughput: 127.78 MBPS, and 200 IOPS

LUN 0_1  on drive [20:1     ] random read throughput: 125.87 MBPS, and 199 IOPS

………...                                                                                                                                 

LUN 0_8  on drive [20:8     ] random read throughput: 128.98 MBPS, and 202 IOPS

LUN 0_9  on drive [20:9     ] random read throughput: 125.46 MBPS, and 200 IOPS

Calibrating flash disks (read only, note that writes will be significantly slower) ...

LUN 1_0  on drive [FLASH_1_0] random read throughput: 544.25 MBPS, and 36275 IOPS

LUN 1_1  on drive [FLASH_1_1] random read throughput: 543.82 MBPS, and 36080 IOPS

LUN 5_2  on drive [FLASH_5_2] random read throughput: 541.41 MBPS, and 36141 IOPS

…………..                                                                               

LUN 5_3  on drive [FLASH_5_3] random read throughput: 502.17 MBPS, and 36036 IOPS

CALIBRATE results are within an acceptable range.

Calibration has finished.

Cell Server 2

CellCLI> calibrate force

Calibration will take a few minutes...

Aggregate random read throughput across all hard disk LUNs: 1473 MBPS

Aggregate random read throughput across all flash disk LUNs: 7064.97 MBPS

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2385

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 88501

Controller read throughput: 2008.34 MBPS

Calibrating hard disks (read only) ...

LUN 0_0  on drive [20:0     ] random read throughput: 130.67 MBPS, and 195 IOPS

LUN 0_1  on drive [20:1     ] random read throughput: 128.76 MBPS, and 195 IOPS

…………...                                                                                                                                                              

LUN 0_9  on drive [20:9     ] random read throughput: 134.11 MBPS, and 202 IOPS

Calibrating flash disks (read only, note that writes will be significantly slower) ...

LUN 1_0  on drive [FLASH_1_0] random read throughput: 539.54 MBPS, and 35125 IOPS

LUN 1_1  on drive [FLASH_1_1] random read throughput: 538.50 MBPS, and 34983 IOPS

………………….

LUN 5_3  on drive [FLASH_5_3] random read throughput: 536.68 MBPS, and 36299 IOPS

CALIBRATE results are within an acceptable range.

Calibration has finished.

Cell Server 3

CellCLI> calibrate force

Calibration will take a few minutes...

Aggregate random read throughput across all hard disk LUNs: 1492 MBPS

Aggregate random read throughput across all flash disk LUNs: 7082.99 MBPS

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2379

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 106158

Controller read throughput: 1999.22 MBPS

Calibrating hard disks (read only) ...

LUN 0_0  on drive [20:0     ] random read throughput: 127.56 MBPS, and 190 IOPS

LUN 0_1  on drive [20:1     ] random read throughput: 128.84 MBPS, and 189 IOPS

…………….                                                                                                                                                             

LUN 0_9  on drive [20:9     ] random read throughput: 124.79 MBPS, and 201 IOPS

Calibrating flash disks (read only, note that writes will be significantly slower) ...

LUN 1_0  on drive [FLASH_1_0] random read throughput: 541.09 MBPS, and 35552 IOPS

LUN 1_1  on drive [FLASH_1_1] random read throughput: 541.02 MBPS, and 35405 IOPS

……….                                                                                                                                                    

LUN 5_3  on drive [FLASH_5_3] random read throughput: 544.38 MBPS, and 47843 IOPS

CALIBRATE results are within an acceptable range.

Calibration has finished.

Now let’s collect aggregate IOPS for Hard disk as well as for Flash disk from all the storage servers as per above output.

Cell-1

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2380

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 113116

Cell-2

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2385

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 88501

Cell-3

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2379

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 106158

Final Calculation

Above result is showing IOPS for each cell storage. Now calculating IOPS for entire Exadata rack by adding all the numbers for hard disk and flash disk.

Storage Cell Hard Disk IOPS            2380+2385+2379         =  7144 IOPS

Storage Cell Flash Hard Disk            113116+88501+106158 = 307775 IOPS


You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.