Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Transaction Log filling extremely fast!Transaction Log filling extremely fast!
Previous
 
Next
New Post
3/28/2008 4:02 AM
 

Paul Norwood wrote

If one of these three tables is the cause of the transaction log filling so fast what is a possible solution?

I see now the rest of my post went missing.  Well, it was a long and detailed response about how each table gets filled.  *slightly annoyed* but I'll try again:

You should first set your database transaction mode to 'simple'.  You're not running an international banking system, you don't need the full level of backup options.  Changing to simple will mean that when you run a transaction log backup it will truncate the log for you.  Your hosting company should be able to help you with this. 

The three tables I mentioned are log tables, and can be safely cleared out with 'truncate table xxxx' where xxx is the table name.  This clears out the table, without logging each delete to the transaction log (and thus making the problem worse) - unlike 'delete from xxxxx'.

- The site log table has a record logged for each request to your DNN site.  IT's an obvious candidate for fast growth, but this should be linear with your visitor numbers, unless you have some sort of redirection loop happening.  You should probably just look at this table to see if updates are going in fast.

-The event log table logs a record for a lot of events, including logons, app restarts and page, module and general exceptions.  It's here that your biggest chance of finding the culprit is.  If you have a page which is causing an exception or 3, then every time you request that page, you are going to get 3 more rows in the table.  Bonus points for logging the exception 'running out of disk space' which is a self-fulfilling prophecy.  I would clear out your event log table with truncate table (seriously, you're never going to read all those log entries) and then wait and see how fast the table fills up.  If it is filling fast, identify the most common records in the table and then troubleshoot from there.

- The schedlue history table contains an entry for each running of a job on the dnn schedule.  Depending on what you've got in your schedule this could be a lot of things running very often (culprits like 'users online' running every minute, that sort of thing).  ANother issue is that the scheduler runs a job called 'purge schedule' and if your schedule history table is too big, the operation will timeout, which will log an exception or 10, then enter some records in the history table, then turn around and schedule itself to do the same thing all over again.   Again, truncate the table and see if it is filling fast.

Most likely it is going to be a combination of things, but you should think about getting rid of unwanted schedule items, clearing out your exception log and turning off your site log and replacing it withe google analytics or something similar.  See what optiosn your host has - some packages come with quite good visitor tracking tools built into the hosting package.  There really isn't a lot of reason to use the DNN site log.

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Transaction Log filling extremely fast!Transaction Log filling extremely fast!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out