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...Anyone else getting lots of Timeouts lately?Anyone else getting lots of Timeouts lately?
Previous
 
Next
New Post
8/28/2008 3:19 AM
 

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I don't know why but I am getting them a lot lately. Not on just one website but all of them. Few of them don't even have any traffic. I use them to test stuff and get these time outs when I am trying to clear the event viewe log, upload a module. What'sn going on? Can anyone please enlight me?

Thanks for your time..

 

 

 
New Post
8/28/2008 4:41 AM
 

I'm getting timeouts, and they are caused by retrieval of ntext fields from my SQL Server database.  Retrieving them through QA on the SQL box is fine, but if I try the same when connecting to SQL Server from another machine via TCP it can take 3 or 4 minutes to retrieve 160 rows.  It's certainly causing me a problem. If anyone has any clues I'd be most grateful.

Barry

 
New Post
8/28/2008 8:52 AM
 

Frozen DNN wrote
 

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I don't know why but I am getting them a lot lately. Not on just one website but all of them. Few of them don't even have any traffic. I use them to test stuff and get these time outs when I am trying to clear the event viewe log, upload a module. What'sn going on? Can anyone please enlight me?

Thanks for your time..

 

 

Sounds like you need to do some database maintenance.  Here is a quick way to clear the event log when you can't do it through the UI

TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog

Your SiteLog may have also reached a size where the scheduler is not able to clear it out.  If that's the case, then you need to delete some rows by using a delete statement.  You may want to delete everything older than 30-days.  You could also just run the statement above but replace EventLog with SiteLog.

I would also check and see how much space you have available in your transaction log.

 

 


Will Morgenweck
VP, Product Management
DotNetNuke Corp.
 
New Post
8/28/2008 2:39 PM
 

Barry,

When you say "...but if I try the same when connecting to SQL Server from another machine via TCP it can take 3 or 4 minutes..." do you mean you are accessing it from a another machine via QA? Or, do you mean via your app.?

Bill

 
New Post
8/28/2008 6:45 PM
 

Hi Bill,

I mean when connecting to SQL Server via SQL Management Studio Express 2005 on my home vista machine or from my live DNN site.

I have two machines, one is running WS2003 with SQL Server 2000, and my Webserver is running WS2008, both Dell machines with AMD 1222 Dual Processors, 2GB RAM and 2x160GB mirrored drives.  I have recently moved to these machines and my DNN site has become very slow so I'm trying to investigate what's happening.  I have one table that it takes a long time to extract nText fields from, unfortunately this table is queried on the home page and sometimes it takes 3 minutes to return 160 rows.  If I run simple queries to extract the data it's much quicker if I do a cast or convert to varchar first.

Barry

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Anyone else getting lots of Timeouts lately?Anyone else getting lots of Timeouts lately?


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