Measuring Storage Performance – Oracle Database

Oracle Orion is a tool for predicting the performance of an Oracle database without having to install Oracle or create a database. Unlike other I/O calibration tools, Oracle Orion is expressly designed for simulating Oracle database I/O workloads using the same I/O software stack as Oracle.

Measuring Storage Performance For Oracle Systems

http://oraclue.com/2009/10/27/orion-oracle-io-calibration-tool-included-in-11g-r2/

Hard disk drive performance comparision

http://en.wikipedia.org/wiki/Hard_disk_drive_performance_characteristics

Device Type IOPS Interface Notes
7,200 rpm SATA drives HDD ~75-100 IOPS[2] SATA 3 Gbit/s
10,000 rpm SATA drives HDD ~125-150 IOPS[2] SATA 3 Gbit/s
10,000 rpm SAS drives HDD ~140 IOPS[2] SAS
15,000 rpm SAS drives HDD ~175-210 IOPS[2] SAS

 

Typical HDD figures
HDD
Spindle
[rpm]
Average
rotational
latency [ms]
4,200 7.14
5,400 5.56
7,200 4.17
10,000 3.00
15,000 2.00

http://en.wikipedia.org/wiki/Hard_disk_drive_performance_characteristics

H/W Evaluation

dmidecode – DMI table decoder

[root@csmsrv-4frh64-nuxeosvn ~]# dmidecode --type
dmidecode: option '--type' requires an argument
Type number or keyword expected
Valid type keywords are:
  bios
  system
  baseboard
  chassis
  processor
  memory
  cache
  connector
  slot

Example
dmidecode --type bios
# dmidecode 2.11
SMBIOS 2.7 present.

Handle 0x0000, DMI type 0, 24 bytes
BIOS Information
        Vendor: FUJITSU // American Megatrends Inc.
        Version: V4.6.4.1 R1.18.0 for D3034-A1x
        Release Date: 11/03/2011
        Address: 0xF0000
        Runtime Size: 64 kB
        ROM Size: 8192 kB
        Characteristics:
                PCI is supported
                BIOS is upgradeable
                BIOS shadowing is allowed
                Boot from CD is supported
                Selectable boot is supported
                EDD is supported
                Print screen service is supported (int 5h)
                8042 keyboard services are supported (int 9h)
                Serial services are supported (int 14h)
                Printer services are supported (int 17h)
                ACPI is supported
                USB legacy is supported
                BIOS boot specification is supported
                Targeted content distribution is supported
                UEFI is supported
        BIOS Revision: 1.18

lscpu – display information about the CPU architecture

Check type of Hardisk

smartctl - Control and Monitor Utility for SMART Disks

smartctl -i /dev/sda
smartctl 5.43 2012-06-30 r3573 [x86_64-linux-2.6.32-358.el6.x86_64] (local build)
Copyright (C) 2002-12 by Bruce Allen, http://smartmontools.sourceforge.net

Vendor:               LSI
Product:              RAID 5/6 SAS 6G
Revision:             2.90
User Capacity:        748,532,269,056 bytes [748 GB]
Logical block size:   512 bytes
Logical Unit id:      0x6003005701451dd0173e81e95f57f757
Serial number:        0057f7575fe9813e17d01d4501570003
Device type:          disk
Local Time is:        Wed Jul  9 14:40:41 2014 IST
Device does not support SMART

http://www.cyberciti.biz/faq/find-hard-disk-hardware-specs-on-linux/
http://www.cyberciti.biz/faq/linux-find-hard-drive-model-rpm-speed/

Storage selection IOPS calculation

http://thecloudcalculator.com/calculators/disk-raid-and-iops.html
http://en.wikipedia.org/wiki/IOPS

[gview file=”http://www.hiteshgondalia.dev/wp-content/uploads/2013/12/disk-raid-and-iops_1388494945.pdf”]

10,000 rpm SAS drives HDD ~140     IOPS[2] SAS
15,000 rpm SAS drives HDD ~175-210 IOPS[2]SAS

http://www.linkedin.com/groups/Storage-selection-IOPS-calc-93470.S.98131072