How to reduce the dnn db size if it gets too big?

The easiest way to get rid of the sitelog is to turn it of in the Host settings and then run from the Host Menu -> SQL:

(1) truncate table Eventlog
(2) truncate table SiteLog
(3) truncate table ScheduleHistory
(4) truncate table SearchItemWordPosition