Hi, im having trouble with ase 12.5.1 on a linux machine. When deleting tuples from a table (with lots of indexes) I get the following output from sp_sysmon:

Recovery Management

Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 4 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 4

Avg Time per Normal Chkpt 264.25000 seconds

If I understand this correctly, the server performs 4 normal checkpoints with an average time of 264.25 sec. All 4 checkpoints therefore takes about 17.5 min!! This is about 80% of the total run time for the deletion.

When inserting a couple of thousant records in the same table sp_sysmon reports the same checkpoint behaviour, i.e. they take weut long time.

This sounds pretty strange to me - Anyone have a clue about whats causing this. When I do the same on a Sun machine with ase 12.5.2 and the same datamodel the checkpoints doesnt seem to take this time (average time = 0 reported by sp_sysmon)