Speeding Up Your SQL Server Connections
At HostNexus we have 3 SQL servers plugged into our Windows servers. Two are SQL 2005 (SQL1 and SQL2) and we have one SQL 2008 server (SQL3). I’m sure most people connect to their SQL server via the public IP or “sql.yourdomain.com” and connecting in this way sends your SQL traffic over the public network switch. We also have a secondary network on all our shared servers and this means you can connect to your SQL Server via the private network IP which will significantly improve your SQL performance in terms of response speed. Here is a list of the SQL servers and their private IPs:
SQL1 (2005) – 192.168.4.15
SQL2 (2005) – 192.168.4.16
SQL3 (2008) – 192.168.4.11
Simply edit your MSSQL connection scripts with the private IP of your SQL server and reap the benefits.
__________________
Laurence - [HostNexus Administrator]
 - Need Support? Quickest reponses are found at the Support Helpdesk!
- Stay in touch! Make sure you are subscribed to our Lists.
|
Linear Mode
