Re: Workload Write vs. Read Ratio

I read your email like this:

* you want to know the charateristics of your applications workload
* you collect some metrics
* now you somehow mistrust your data as you know there is more you can

just give it a try: try if you find a good correlation between the workload and the metrics you collected. (Excel is fine in doing so) If the correlation is good, you are lucky. otherwise you have to find more/other metrics.

that's not the best answer, but hopefully a start  Martin

On Fri, Nov 18, 2011 at 22:16, Steven Andrew <postora_at_gmail.com> wrote:
> All,
> I have this little thing nagging me for a while and would like to get
> opionion from others. For capacity planning excercies, we generally
> monitor the metric 'physical read total IO requests' and 'physical write
> total IO requests' over a period of time to get IOPS. I see that Read
> requests to be around 200 and Write request around 2000. Does this mean the
> application workload is write intensive with write vs. read ratio of 90:10.
> What about all the caching that's done at the SGA for reads, likewise SAN
> caching for write. Shouldn't that be accounted as well when it comes to
> knowing the workload pattern of the application. How would you go about in
> knowing the workload ratio for an existing system.
>
> TIA,
> Andrew.
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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