on 05-11-2016 10:05 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
overall statistics are provided by:
sp_iqstatistics
Best regards,
Juergen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.