cancel
Showing results for 
Search instead for 
Did you mean: 

IOPS or IO MB/s statistics ?

Former Member
0 Kudos

Hi, experts

Env

-------

IQ 15.4 /LINUX

How to get IO statistics of dbfiles or overall?

IOPS , IO MB/s, average read time ..


Thanks in advance 

Accepted Solutions (0)

Answers (2)

Answers (2)

c_baker
Employee
Employee
0 Kudos

Are you looking at how to make IQ faster?  The general rule of thumb is ~50-100MB/sec/core is the bandwidth required from the disks.

Another metric would be to use 1-3 spindles per core (e.g. SATA disks are ~30MB/sec each) for mechanical drives.  SSDs are faster, but you still need to watch the bandwidth of the SSDs used.

IIOPS can be calculated from there based on the IQ page size, but throughput is a better metric.

You can use iostat (e.g. iostat -d -p -t -x -m 4) to see what the the performance of your devices are and see if you are getting a lot of waits (you would get this, for example, when you place IQ dbfiles on the same device or in partitions on the same devices).

Have you read the IQ sizing guide or best practices documents?

http://scn.sap.com/docs/DOC-46166

http://scn.sap.com/docs/DOC-39896

Chris

Former Member
0 Kudos

Thanks for your explanation...

hans-juergen_schwindke
Active Participant
0 Kudos

Hi,

overall statistics are provided by:

sp_iqstatistics

Best regards,

Juergen