RE: SQL Benchmarking
> Brian Foster
> how can I ensure that data is being read from disk rather than from the
> buffer? I am moving data between 2 database instances (with
> insert/select)and would like to compare performance relative
> to differing configurations/settings.
>
If you can control the work going on, a quick and rough way would be to
use onstat -p between sessions.
Similar but with more info would be something similar to
select
tabname tab,
isreads isrd,
bufreads bufrd,
pagreads pgrd,
iswrites iswr,
bufwrites bufwr,
pagwrites pgwr,
lockreqs lkrq,
lockwts lkwt,
deadlks dedlk,
seqscans seqs
from sysmaster:sysptprof
where tabname not matches "sys*"
order by pagreads desc;
Colin Bull
c.bull@videonetworks.com
sending to informix-list