Rates of change???
From: Madison Pruet <mpruet_at_attbi.com>
Date: Sat, 28 Jun 2003 18:10:21 GMT
Message-ID: <hSkLa.43291$Fy6.13123_at_sccrnsc03>
Date: Sat, 28 Jun 2003 18:10:21 GMT
Message-ID: <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..