Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Server load balancing and SQL

Avatar of rfinaly
rfinaly asked on
NetworkingServer HardwareMicrosoft SQL Server 2005
4 Comments1 Solution254 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Avatar of Froggy_chris
Froggy_chris

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers