Re: Gather IO stats

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 1 Aug 2006 17:07:07 -0700
Message-ID: <1154477227.097882.220260@h48g2000cwc.googlegroups.com>

mngong_at_gmail.com wrote:
> Your answers are greatly appreciated Charles Sybrand and Daniel.
> The original question was about a query that does the subtractions.
> Statspack and Charles query will give the information needed but
> manually adding/subtracting
> may lead to some errors
> Thanks again for your input

If you created the logging table, and you can make certain that the information is gathered at regular intervals, it is very easy to automatically compare the results:

Logging table: FILE_ACTIVITY, capturing every 30 minutes (1 day divided by 24 divided by 2), example:

SELECT

  FA2.TIME_STAMP,
  FA2.FILE_TYPE,
  FA2.FILE#,
  FA2.PHYRDS - FA1.PHYRDS PHYRDS,
  FA2.PHYWRTS - FA1.PHYWRTS PHYWRTS,
  FA2.PHYBLKRD - FA1.PHYBLKRD PHYBLKRD

FROM
  FILE_ACTIVITY FA1,
  FILE_ACTIVITY FA2
WHERE
  FA2.TIME_STAMP=(FA1.TIME_STAMP+1/48)
  AND FA2.FILE_TYPE=FA1.FILE_TYPE
  AND FA2.FILE#=FA1.FILE#
ORDER BY

  FA2.TIME_STAMP,
  FA2.FILE_TYPE,
  FA2.FILE#;

If you have a lot of records, consider indexing the various columns.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Aug 01 2006 - 19:07:07 CDT