Re: How to caliculate the IO Demand for IOPS and ThroughtPut

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: andrew.kerber@xxxxxxxxx
  • Date: Mon, 20 Jun 2011 13:14:03 -0500

Andrew-et all,

You might see inflated IOPS when you use 'physical reads' or 'physical
writes' in the equation. The metric 'physical reads' records the number of
block requests and a block requests will always be higher than IO requests.
 Use 'physical read/write  IO requests' while calculating disk IOPS.

Also disk IOPS might be significantly higher than the database IOPS when you
add the RAID/parity overheads.

-Gopal

Other related posts: