AnsweredAssumed Answered

Search way to shrink database table "event_log" faster

Question asked by ahd on May 9, 2018
Latest reply on May 9, 2018 by Chi_Chen

Hi all,

 

I know that I can use a deletion rule in the SDM to specify the event log myself and thus delete logs from the database. This I have applied but strangely enough it takes a very long time.
Currently I see that my MSSQL table "event_log" is about 4.9 GB in size. Is this size normal? That seems very big to me.
Anyway, I wanted to reduce this table with the delete rule. Unfortunately, after a runtime of one day he has deleted only 400MB from this table and the rule is still running.
We want to reduce the size of this database or this very large table again, because this is only our test environment.

Is there an easy and quick way to reduce the size of this table except for the deletion rules shown here in the web interface itself? The arcpur.log has actually a size about 400MB.

 

Many greetings,
Tobias

Outcomes