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...DNN Sites Constantly Go Down!DNN Sites Constantly Go Down!
Previous
 
Next
New Post
5/28/2008 11:26 PM
 

Slavic Kozyuk wrote

 

Compression setting: No compression (Although the idea behind the HTML output compression is good, in reality the CPU overhead makes it slower than raw output)

 

Slavic,

Can you please elaborate more on this issue? What's the result in dedicated server? Which is better, CORE compression or IIS compression?

Thanks,

Duc

 
New Post
5/29/2008 12:52 AM
 

DNN itself has scheduled tasks to keep the log size down, but what often fails for people is the actual Sql Server log file.  Each insert/update/delete is logged in Sql Server tranaction logs, so if you have a database corruption you can restore back to the point of failure.  A lot of installations of Sql Server 2000/2005 have logging setting far in excess of what is needed for a simple website.  You aren't storing complex financial transactions between banks, so you don't need the top level of logging.

Just set the Sql Server log type to 'simple' and when the daily backups run, get the truncate log on checkpoint to run.  This will keep the Sql Server transaction logs down to a reasonable size.  You can truncate the DNN log tables on a regular basis if you like, but there are scheduled tasks and settings within DNN to achieve this.

My suggestion for the 'long' startup time?  Do some SEO and get yourself some traffic.  Any site with a decent number of visitors isn't going to unload itself.  What's your site for, anyway, if not to attract visitors??

 
New Post
5/29/2008 12:58 AM
 
Slavic,
The SiteLog/EventLog  bloating is a real pain and I have to watch it all the time with my clients.
I use TRUNCATE TABLE SiteLog TRUNCATE TABLE EventLog manually.
I would appreciate any suggestion for a methode to run it automatically.
Is it possible to run it from the scheduler? If yes, is there any ready to go script for that?
(Actually I am surprised that I did not see this request before.)
Thanks for any help on this,
Yehuda
 

Yehuda Tiram
AtarimTR
AtarimTR
972-2-5700114   |   972-54-4525492   |    http://www.atarimtr.co.il
 
New Post
5/29/2008 9:37 AM
 

[QUOTE]duchoangle wrote

Slavic,

Can you please elaborate more on this issue? What's the result in dedicated server? Which is better, CORE compression or IIS compression?

I doubt there is much difference here, just don't use both.



Alex Shirley


 
New Post
5/29/2008 3:19 PM
 

Our implementation of “house keeping” scripts resides on the SQL server as a DTS package. Essentially, on a scheduled basis the DTS job traverses all databases, checks each database to make sure it is a DNN database, then checks the DNN database version, runs truncation, shrink, index rebuild, query plan optimization, and other tasks as part of the routine.

 

You have to keep in mind that we host other applications that have their own unique requirements. Also, older DNN versions have different database schemas and this must accounted for in the maintenance logic.


Affordable DotNetNuke Hosting Affordable DNN Hosting & Support - www.ihostasp.net
Slavic Kozyuk
IHOST, LLC
Call toll-free: 1.800.593.0238
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN Sites Constantly Go Down!DNN Sites Constantly Go Down!


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