Allan,

> And what, exactly, was the intended use of the MON tables? Are you
> supposed to query them once or twice a day? I see no benefit in that but
> I'd love to
> know what benefit could be derived from few and infrequent queries. IMO,
> snapshots are pretty meaningless unless you have a stream to analyse.

The new (v2.5) Trace functionality is intended to allow for you to monitor server activity and find long running/sub-optimal statements/activities.

The MON$ tables are more suited to having a glimpse of what is occurring "now" but not to be asking the question every x seconds.


Sean