Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[txtxcowboy]

My site (all .ASP) has recently been giving the following errors to users intermitantly. If they refresh usually the page will render. Site has over 20K users with 50-400 online at any given time. Any idea what the issue could be??

Here is the error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver]Timeout expired


please let me know if you have any ideas!!!

 

[Durkin]

This problem could be cause be a lot of things. Your database may have grown to such a size that it now takes a bit longer than it used to to return data. This may be helped by shrinking your database. Also maybe you need some new indexes on tables that are queried frequently. Another thing worth trying is optimizing any stored procs that are used. Also, check for deadlocks. The last thing I can think of off the top of my head is, if none of the above work you should be able to increase the timeout property of your database connections.
Basically, if this is only a recent thing then some has changed from when you went live. Whether this is due to an increase of data or an increase in the amount of users is hard to say and can only be found really by someone with access to the system. These kinds of problems are often a real pain if they are intermittent because it's sometimes quite hard to reproduce them at will. Still, timeout problems are usually not too hard to track down so good luck. ;-) Durkin

 

[txtxcowboy]

Thanks Durkin, I will definetly check out your suggestions...

Thanks again!!