Re: Rates of change???

"Madison Pruet" <mpruet_at_attbi.com> wrote in message news:<hSkLa.43291$Fy6.13123_at_sccrnsc03>...
> 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..

Madison -
Couldn't you use triggers on the table to capture a timestamp for each update or insert, and log that info into an audit table? You could then have a procedure that would run against the audit table, providing some summary info such as the rate of change. Is this at all what you're looking for? Received on Sun Jun 29 2003 - 19:22:52 CEST