sql server (alternate): Rates of Change... -- sql server (alternate)

Rates of Change...

Madison Pruet
6/28/2003 6:18:04 PM

sql server (alternate):

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..

Re: Rates of Change...

CJ
6/30/2003 4:23:52 PM

You could also create INSERT and UPDATE triggers on the table in question
that would INSERT a record into a separate table. Everytime a record is
inserted and updated a new record would be inserted into a history table.
This may create performance issues which Erland's solutions do not.

CJ
[quoted text, click to view]