Navigate
X

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 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.
Related Post
  1. Migrating Into HostNexus

    You've made a great choice to host your WordPress websites and your first task is…

  2. The Problem With Addon Domains

    (more…)

  3. PHP 7.2 Released and Available

    (more…)