SQL connection problem when remote users access server?

Question

Remote users have ODBC on each of their computers.  We access the server from our main office, but the connection is soooo slow, and most often then not, we get disconnected.  

Any body know if packets can be re-sized when sending data? If so how?

Or is the only option to get a higher bandwidth? (sheeeez we hope not, 'coz this'll mean we have to wait for budget approval which'll be when hell freezes over...)

howlingengines · Accepted Answer

youve obviously got a lot of concurrent ODBC connections which may be taxing the server ( it has to keep track of all this). A/ ensure you got enough memory/temp space on your DB system;B/ you may care to rebuild your application so that there is a central DB access layer with a pool of ODBC connections , and the client machines use a socket connection ( or even web services) to the DB access layer to operate on the DB. If your client application is layered right , this shouldnt be too difficult.

Kelly O · Answer

I am going to assume that you're using Microsoft. The packet size has to be reset for your entire network, I don't see a way to change them just for remote connections. This has to be done by the system administrator. You might not see the performance jump you need however just by doing this, I think upgrading your connections would be the best plan.

jmfc · Answer

hmmm, a few thoughts. make sure they are using an internal IP and not an external one. your sql server probably shouldn't be opened up with an external IP for security reasons. also, if it is using the network name like 'sqlserver' try switching to the intenal ip. it really shouldn't be taking up much bandwidth unless you are getting huge amounts of data

Trending News

SQL connection problem when remote users access server?

3 Answers