Web Hosting

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. :)

About the author

Laurence Flynn

Hey! I'm Laurence, hosting industry veteran and entrepreneur, obsessed with web performance. My aim is to build the cheapest and fastest Optimized WordPress Hosting platform available today. Our back-end systems include Nginx and Redis combined with PHP 7, FPM and MariaDB to deliver maximum performance. Our front-end UI is powered by the beautiful Plesk control panel to deliver a smooth user experience. All secured with Imunify360, artificial intelligence and machine learning. Connect with me on LinkedIn.

2 Comments

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • This is very cool. You say that the shared servers are all on a secondary network, but what about dedicated servers? I recently moved to a dedicated windows server with you guys and I’m running Coldfusion apps on it. Can I just substitute the 192 address in my CF Admin panel and “reap the benefits” of the faster connection?

    Thanks!
    eric

    • Hi Eric,

      The dedicated servers aren’t configured by default to hook into the SQL private network but I think it can be done for an extra $10/mo (for the cross-over cable/switch). If you’d like me to see if it canbe done for your server please contact me at Sales.