Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:28:53
|
| Mandy writes "We have approx 90 users connectioning via a web app to our SQL Server. If we reboot the webserver the SQL Server seems to be fine for a while and then it seems to go into tiz. The tables and db becomes inaccessable even from Query Analyzer. The users start experiencing the following error:Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired " |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-16 : 15:47:37
|
This is most likely an ASP problem however a very common one. Search for your error on google and you get around 10000 hits i.e. pages that timed out when its crawler was accessing them  You can try increasing the timeouts and also using Profiler and maybe NetMon to capture traffic when this occurs to troubleshoot.Also check out [url]http://www.aspfaq.com/show.asp?id=2066[/url]That's not to say it couldn't be due to poorly optomised SQL but the fact that rebooting the web server sorts it suggests that's where to concentrate your effortsHTHJasper Smith |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-16 : 16:15:00
|
| Another thing to look at is sp_locks and sp_who2.They can tell you if a user / connection is creating a lock which is blocking all other requests to that table. Maybe some process that runs once a day maybe?Just a thought.Michael<Yoda>Use the Search page you must. Find the answer you will. |
|
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-07-16 : 16:52:42
|
| Another possibility is that you have the SQL Server registered by IP in the Client Network Utility.If it's true, add the server name and IP to the hosts file in System32\drivers\etc path and update the Server Connectivity in the tool above, to use the name of the server instead of IP.Sérgio Monteiro |
|
|
|
|
|
|
Timeout Expired