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 |
|
bryan99y
Starting Member
42 Posts |
 Posted - 2003-06-20 : 10:58:46
|
| I have a choice to go with either 2 DB Servers or 4 DB servers in a clustered environment.Rules:- I want minimum 2 DB working at the same time serving data to a bunch of ISS boxes.- I also want Load Balancing here.- I want the flexibility to put another DB server in the cluster if load gets higher over time.What is the best solution?What is the cheapest solution? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-06-20 : 11:12:35
|
| You should read more about clustering SQL Servers as this is not a technique for load balancing.Jay White{0} |
 |
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-20 : 11:56:41
|
| aware of that.would like advice on using 2 or 4 servers... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-20 : 12:38:09
|
| Well, 4 servers would be the best solution, 2 servers would be the cheapest, and again, we can't advise you on load balancing because SQL Server does not do that natively. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-20 : 13:04:44
|
| We've got 2 database servers in a clustered environment. We have almost outgrown it already. We would have gone with 4 initially, but these servers have 4 CPUs and we use Enterprise Edition of SQL Server, so licensing costs is a huge factor for us. I would definitely recommend 4 database servers if you have the option.Tara |
|
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-20 : 13:44:44
|
| tduggan- do you have an active/active or active/passive setup? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-20 : 13:57:12
|
| We have an active/active setup.Tara |
|
|
|
|
|
|
Clustering