SQL Server Timeout

[rsshetty]

Not sure if it shoud be a sql server question or else where.
I was wondering if a user had a dial up connection and was trying to view a webpage that had some pretty heavy duty queries and there was a timeout error, would that be a sql server issue or is it because of the user using a dialup connection?

rsshetty.
It's always in the details.

 

[jbenson001]

Depends on the timeout error. If the query is very long, it could be the SQL Server timeout parameter. But it could be the timeout parameter in the web app. Or could be a timeout issue with the connection. Perhaps it could timeout after a certain period of inactivity.

Jim

 

[rsshetty]

The problem is I am not sure which one it is and the timeout errors are increasing. I was told by the tech guys that the SQL server is running a little low on memory. AT the same time, the queries are pretty heavy duty. Add to that, we have users who use dialup connections.
Any suggestions?

rsshetty.
It's always in the details.

 

[jbenson001]

Suggestions:
More memory on the server.
Optimize the queries.
Restrict data being returned by the queries.
Suggest to the end users to use a better connection type if possible.