Click here to Skip to main content
15,922,533 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I want to configure load balance cluster in SQL server, how to manage that, please can any one help me.

What I have tried:

I didn't try yet, Cause this is first time for me, My company ask me to this senario
Updated 19-Mar-18 1:07am

1 solution

Start here: Load Balancing with SQL Server - Database Administrators Stack Exchange[^]
load balancing sql - MSDN[^]
If these aren't relevent then give us more information about your set up (SQL version, Database is Azure/not Azure)
Share this answer
ABAKh 20-Mar-18 11:36am    
I appreciate your answer, as i knew that in SQL Server there is no load balance cluster, and instead of it there is fail over cluster, the question is, can i configure it while the database is working or before that, i mean on the installation of the database stage. Thank you a lot.
CHill60 20-Mar-18 12:16pm    
You are not being at all clear with your question. Do you want to implement Load balancing or a failover cluster? I'm pretty sure neither can be done while the database "is working", you would have to stop the services and potentially reinstall or upgrade the SQL instance.
This sort of thing is somewhat off-topic for a "quick answers" programming forum - perhaps you should ask your company for some DBA training if they are going to ask you to do stuff like this

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900