Refresh dbcc sqlperf(logspace)

[pd]

Hi,
I have to monitor log.
I am using dbcc sqlperf(logspace).
I need to refresh it evry 15-20min.to monitor the growth(ofcourse in %)of log files.
How is this possible if I do think of 'automating' it?
TIA
pd

[cal]

create a store procedure
using temp table with data from dbccc sqlperf(logspace).

query the temp for percent used for the specified threshold set.

alerts if greater than threshold.




------------
pd at 3/23/01 1:08:07 PM

Hi,
I have to monitor log.
I am using dbcc sqlperf(logspace).
I need to refresh it evry 15-20min.to monitor the growth(ofcourse in %)of log files.
How is this possible if I do think of 'automating' it?
TIA
pd