If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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)