Solved

Server load balancing and SQL

Posted on 2009-05-08
4
226 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Disable network connection item via group policy? - is this possible? 4 39
Applying Computer Settings 12 89
VLAN 1 Line Protocol Down 9 40
Network adapter failed to start 5 38
Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

749 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