November 30, 2006 at 11:41 am
Can anyone possibly give me some pointers on how to speed up access to a central SQL Server from 3 remote sites. Currently 2 of the sites use 3mg DSL and the other uses Broadband Cable 3mg. All are VPN's into the server through SonicWalls. This topology is extremely slow almost to the point it is not worth doing. Both DSL sites have 256k up and the cable has 384k up, there is no noticable difference in the two up speeds. What is the proper way to set this up? Maybe point-to-point T-1's. There has to be a more productive way to do this. Thanks for your assistance with this.
Mike Stokes
December 1, 2006 at 2:24 pm
What is it that your remote sites are doing with the central SQL Server? Are terminal servers or Citrix servers or remote connections of some sort an option?
For example, we have 2 SQL Servers as Facility A. We have users at Facility B that have applications that use databases on those SQL Servers at Facility A.
For the group that's at Facility B that's running simple reports, they pull the data over in a point-to-point T1. For the group at Facility B that is running a more intensive application, they RDP into a terminal server at Facility A and then run their application via the terminal server.
When it comes to SQL Server administration and I'm offsite, I RDP in to a terminal server at Facility A and then I can remotely connect to the SQL Servers from there. It's quicker for me to RDP in than to use our VPN. And I have a cable connection at home.
December 1, 2006 at 5:57 pm
Thanks for taking time out of your day to post to this question. I'm not sure I can be brief in explaining this.
My Facility "A" houses the SQL Server that has the following simultaneous users. We are a time and service company that utilizes a Dispatch program that queries the SQL Server. The name of the program is ESC (Electronic Service Control) and is a Client Program that runs independently on each PC terminal. I have 5 Dispatchers, 3 accountants, and 4 sales / inventory users at this location.
Facility "B" has 3 Dispatchers, 2 sales, and 2 bookkeepers that utilize the ESC program simultaneously.
Facility "C" has 3 Dispatchers, 2 sales, and 3 bookkeepers that utilize the ESC program simultaniously.
Facilities "A" and "C" use DSL (3mg Down / 256k Up) and "B" uses Cable Broadband (2mg Down / 384 Up). I use SonicWall at all sites with VPN tunnels to Sites "B" and "C" from Site "A"
The above topology is not worth doing at all. It is extremely slow for some reason. There is a 2 to 5 minute lag in the time of server response. I'm not sure if it is the Up Speeds at each location or just the SQL Server Up Speed. Or maybe it is the VPN Tunnels. Whatever it is I need to do something different. I have been considering Point-to-Point T1's to solve the problem but this is very expensive. On the other hand Cable Broadband can now offer us 3 or 5mg down / 1 mg Up at quite a savings over T1's. We are to open 3 more offices in the coming year and we can not continue like this. Hope you can shed some light on this shortcoming. Thanks again for responding and sorry about the book here.
December 2, 2006 at 12:35 pm
Do you have someone measuring bandwidth usage? Possibly from individual machines? What about running Profiler and seeing how much and how quickly traffic is being sent to and processed by SQL Server?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply