File:Ldmeter.sql

Here is the meter script I mentioned on the call. Load this with isql and then start by running a single isql with the command ld_meter_run (600) for a sample every 600 seconds. This does not return but can be stopped by killing the isql that started it.

The data gets written into the table ld_metric. To take an extra sample, just call ld_sample from any client session.

The load rates are accurate if there is no other activity on the rdf tables during the measurement.

Orri