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

From: Karl Arao <karlarao_at_gmail.com>
Date: Mon, 20 Jun 2011 13:53:21 -0500
Message-ID: <BANLkTi=T76NpU0qgnDWrs9Yk-GLLRBAEsg_at_mail.gmail.com>

Yes I agree with Gopal, from what I've seen on some of my benchmarks and on the client site the OS statistics on IO may be much higher than the Oracle stats.

So my take on that.. The Oracle IOPS numbers will still be a good start or reference on your storage decisions at least your sizing is not based on guess work or wild guesstimates.
If your concern is the OS and Oracle numbers don't match. I would say it doesn't vary greatly... but I would be cautious too and will have conclusions based on the OS statistics as well as based on Oracle statistics.

Also when sizing for storage, you would also need to consider not only the IOPS but also the following:

1. Type of IO and workload
   - Small random IO
   
   • Large sequential IO
   • Large random IO
   • Mixed workloads
2. Read/write ratio
3. Throughput requirement (MB/s)

but your overall objective here is you must have more Capacity (performance) than your Requirements. So you wont end up having an IO bottleneck.

-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 20 2011 - 13:53:21 CDT