Server load balancing and SQL

Posted on 2009-05-08
Medium Priority
Last Modified: 2012-05-06
Dear Experts,
I am looking for some advice on technology.
Here is my issue: I have 3 Web servers that hosting 3 Web applications, all applications pointing to the same database server. I would like to create some load balancing for the SQL 2005 server and the Web applications servers, my vision is to be able to point users to another server if the current server have to much load on it, for example: assuming I have 100,000 customers using server 1, I would like to find a technology that will redirect users to server 2 if server 1 have 50,000 users. Now the tricky part is that server 2 will also point to database server 2, however from my knowledge I know you cannot have 2 SQL servers connected to the same database on the storage.
Is there any technology out there that can help with this? how enterprises that have millions of customers handle the load of the web servers and database server?
Thank you
Question by:rfinaly
LVL 15

Expert Comment

by:Faiga Diegel
ID: 24339984

Have you research on MS Windows Load Balancing technology? I think that would help you. For SQL part, you don't have to worry about thousands of concurrent connections, SQL server can handle it. You just have to consider things such as: multithreading, AWE, memory, databse design/model, locking/blocking, etc.
LVL 35

Expert Comment

by:David Todd
ID: 24340095

Are all the applications using the same database on the database server?


Author Comment

ID: 24340963
All the applictaions using the same database which locate on one server of course.

Accepted Solution

Froggy_chris earned 2000 total points
ID: 24374917
Hi rfinaly,

To reach what you want:
- make your database server strong (Cluster, if possible 64bits) with enough CPU. memory & storage IOPS to handle the load.
With properly written application & the right server set, SQL will be able to handle.
And in doubt.. stress-test.
Having two server serving the same DB will not be easy (if ever possible) as SQL handle a lot in memory..

- Front-End:
Join all your web-server in a NLB cluster. You have the Windows NLB cluister, easy to setup but need to be very careful with Cisco switches, or you can buy a cluster of Hardware load-balancer (with your figure, it would be my first choice)


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article I will be showing you how to subnet the easiest way possible for IPv4 (Internet Protocol version 4). This article does not cover IPv6. Keep in mind that subnetting requires lots of practice and time.
LinkedIn blogging is great for networking, building up an audience, and expanding your influence as well. However, if you want to achieve these results, you need to work really hard to make your post worth liking and sharing. Here are 4 tips that ca…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question