Hi,

Is there an easy way to determine the rate of change for table? I realize
that I could do periodic select count(*) from XXX, but that would only
determine the size of the table. It would ignore updates.

What I'd really like to do would be able to determine the number of non-read
operations over a table so that I can determine the rate of change for that
table.

Thanks for any help..

Rate of change implies count of changes per unit of time. The way you could do this
is by having a change table with a count column and a datetme column. An insert
trigger on the data table will get the current time, and if it's less than one minute
later than the latest datetime stored in the change table, the trigger incrments the count
column of that latest change table column with the count of the currently changing rows,
otherwise the trigger makes a new row in the change table with the current time and a
count equal to the current count of changed rows in the data table.

Joe Weinstein at BEA

Madison Pruet wrote:

Thanks.

I'd prefer to find some way to do this without having to impact user
application performance, so would rather avoid having triggers.


"Joseph Weinstein" <joe.remove_this (AT) bea (DOT) com.remove_this> wrote

Madison Pruet wrote:

"Madison Pruet" <mpruet (AT) attbi (DOT) com> wrote:
Another way is auditing. With
sp_audit 'update', 'ALL', 'OWNER.TABLE', 'on'
sp_audit 'insert', 'ALL', 'OWNER.TABLE', 'on'
sp_audit 'delete', 'ALL', 'OWNER.TABLE', 'on'
you'll get a record of every update, insert and delete statement
to the table. This doesn't record the number of rows affected.

Regards,
Mariano Corral