Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Schduler Ooops!Schduler Ooops!
Previous
 
Next
New Post
6/25/2009 7:03 PM
 
Dr Pat

Joined: 4/2/2008
Posts: 37

 Hi,

 

I was trying to figure out why my db keeps growing exponentially and was looking through the scheduler. I decided to Enable a few of the scheduled events to see if this would help: PurgeUsersOnline, PurgeSiteLog, PurgeLogBuffer, and PurgeCache.

When I did this it has now left the install DEAD! All I get is: [HttpException (0x80004005): Request timed out.]
DNN: 4.9.3
 
Do you know if there is a way to undo these changes manually - in a config file or something on the server? I tried swapping my web.config for an older version but this had no affect.
 
I am pretty sure this is something that would require sql - if someone can point me in the right direction I would appreciate it.

I appreciate your help.
Cheers,
Pat

 

Healing the world one spine at a time. Chiropractic Websites using the DNN Framework.
 
New Post
6/26/2009 3:37 AM
Accepted Answer 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

You can disable the jobs by executing the following SQL from Management studio:

UPDATE SCHEDULE SET enabled = 0 WHERE TypeFullName Like '%Purge%'

subsequently, you should examine which of the tabled exaggerate size, e.g by running (separately) the following commands in Host :: SQL text box:

SELECT Count(*) FROM {databaseOwner}{objectQualifier}SiteLog

SELECT Count(*) FROM {databaseOwner}{objectQualifier}EventLog

SELECT Count(*) FROM {databaseOwner}{objectQualifier}ScheduleHistory

SELECT Count(*) FROM {databaseOwner}{objectQualifier}SearchItemWords

Also make sure, the database gets backed up frequently with truncating the transaction log, if using full recovery scheme.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/26/2009 10:15 AM
 
Dr Pat

Joined: 4/2/2008
Posts: 37

Hey Sebastian,

You are the man!! That worked perfect!

I got the scheduled sql jobs module from IowaComputerGurus.com which has significantly slowed the growth of the database but I still have to run a sql to truncate the log files manually at least once a week. Is this normal?

I haven't done the sql's you mentioned above yet but I am assuming that these will tell me which part of the db is growing so fast.

To give you an idea of how fast it is growing the db after truncating the logs and shrinking is less than 20Mb and at the end of the week it will be 350Mb. If I leave it a couple weeks it will freeze when it goes over 800Mb. Before adding the scheduled jobs it would grow twice as fast.

The install has 63 blog portals. I figured that the blogs must be creating more logs than the other portals as my other installs which are configured exactly the same don't behave this way.

Is this normal for blogs or is there some configuration which would improve this situation?

Thanks,

Pat

Healing the world one spine at a time. Chiropractic Websites using the DNN Framework.
 
New Post
6/26/2009 12:34 PM
 
Dave Buckner


www.DaveBuckner.com
Joined: 1/1/2005
Posts: 300

Dr Pat wrote
 

Is this normal for blogs or is there some configuration which would improve this situation?

Hi Pat,

This is from the recovery modal your database is using. It sounds like your DB is currently using the Full modal. This can be changed to something like simple, however you need to be aware of the pros and cons. There is a article here that explains this a bit more.
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Schduler Ooops!Schduler Ooops!


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