Two of the most common tables to take up space are the EventLog and SiteLog tables.  To see how much space each is using you can run the following SQL Scripts from your Host -> SQL Menu.  (NOTE: if you have an object qualifier you must append it to the table name!)

SP_SPACEUSED EventLog

The above will get you the size of your event log table

SP_SPACEUSED SiteLog

The above will get you the size of your site log table

These are two of the most common database size issues.  You can truncate either or both tables if needed, just remember what the data represents before making the decision.  I personally do not use the SiteLog as I find it to be too heavy on db usage both in performance and overall db size.

---

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.


Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services