Solved

Server load balancing and SQL

Posted on 2009-05-08
4
224 Views
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
0
Comment
Question by:rfinaly
4 Comments
 
LVL 15

Expert Comment

by:faiga16
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.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 24340095
Hi,

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

Cheers
  David
0
 

Author Comment

by:rfinaly
ID: 24340963
All the applictaions using the same database which locate on one server of course.
0
 
LVL 6

Accepted Solution

by:
Froggy_chris earned 500 total points
ID: 24374917
Hi rfinaly,

To reach what you want:
Database
- 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)

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

803 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