hi all. We have a sql server currently support 100+ sites/web services and i am thinking of creating dynamic routing for this sql server. which means whenever the first sql server reaches its limits. it will automatically redirect all the request to second web server with another sql server installed. (load balancing ?)
can I ask how can we achieve it?