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..

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.

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