Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MontrealDBuser
Starting Member
2 Posts |
 Posted - 2008-05-08 : 14:25:39
|
| Hello All,I need some help with a web application we are running. Is it possible to have 2 seperate instances of SQL 2005 running and each one pointing to the same DB. We want to load balance our users on the different DB servers. They are performing read and write transactions.Any suggestions. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-08 : 14:30:50
|
| Didn't get you question clearly? Having seperate instances won't balance load. what is your requirement? |
 |
|
|
MontrealDBuser
Starting Member
2 Posts |
Posted - 2008-05-08 : 14:38:01
|
| We are running an application that is providing serious performance issues from the DB end. We want to point 2 of our application servers to one db server and 2 application servers on the other db server, both DB servers would point to the same db. I am told it is possible. We are hoping to avoid replication since it tends to create a lot of overhead.So, we will do the load balancing but we are simply hoping to provide additional processing power until a more permanent solution is found. Time is critical here. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-08 : 22:30:09
|
| Take look at 'federated database' in books online. It's not true load balancing, but may help. For performance issue, I'll start from query optimization. |
|
|
|
|
|
|
2 SQL05 Servers with One Database