Sometimes DotNetNuke DataBase Grows Very Fast

This is very popular problem of DotNetNuke. DB grows very fast, ever you do not add any new modules and content is the same. The most popular problem is quick growing of the log tables SiteLog and EventLog.

One of my clients had this problem, because have been attacked by hackers and log grows very fast with errors. Another is because installed bad written module and this module throws a lot of exceptions.

You can check how many  records in each table with query like this:

SELECT COUNT(*) FROM {databaseOwner}{objectQualifier}SiteLog;

and

SELECT COUNT(*) FROM {databaseOwner}{objectQualifier}EventLog;

You can compare number of records for small period of time (for example 1 hour). If it grows fast, then here is a query to fix problem:

TRUNCATE TABLE {databaseOwner}{objectQualifier}SiteLog;
TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog;

This query removes all records from these tables. It can be runned from Host/SQL menu.

Hope this helps!