January 8, 2009 05:21pm pst

1. andrew_... 8,000
2. andyalder 7,875
3. SysExpert 6,000
4. leew 4,725
5. lnkevin 3,580
6. rdhoore108 3,510
7. dariusg 2,750
8. gheist 2,500
8. tedbilly 2,500
10. paulsolov 2,150
11. meugen 2,000
11. m_adam... 2,000
11. simsjrg 2,000
11. giltjr 2,000
11. travisgish 2,000
11. Chicago_... 2,000
11. MrWid 2,000
11. Krys_K 2,000
11. takendown 2,000
11. hodgeyohn 2,000
11. mark_wills 2,000
11. dstewartjr 2,000
11. suppsaws 2,000
11. TechSoEasy 2,000
11. macker- 2,000
11. mkbean 2,000
11. richrumble 2,000
11. CarlWebs... 2,000
11. mass2612 2,000

1. lnkevin 684,964
2. andyalder 560,441
3. leew 202,560
4. rindi 163,665
5. SysExpert 145,909
6. KCTS 135,610
7. 65td 101,757
8. meyersd 101,641
9. PUNKY 97,378
10. tigermatt 94,700
11. TechSoEasy 86,418
12. RobWill 85,824
13. JjcampNR 64,820
14. jamietoner 63,987
15. sandybridge 57,442
16. garycase 52,920
17. Callandor 48,026
18. andrew_... 41,726
19. ryansoto 39,119
20. akirhol 38,514
21. sifuedition 38,434
22. simsjrg 36,440
23. oBdA 35,500
24. arrkerr1... 32,857
25. honmapog 32,375

09.27.2007 at 11:06AM PDT, ID: 22857472

	[x] Attachment Details

Load Balancing Options

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

Zones:

Computer Servers, Windows 2003 Server, Storage Technology

Tags:

balancing, sql, server

Here's the situation...

We have a production environment consisting of an app. server running IIS that has a few applications on it. Then, there's another server that has Windows Server 2003 and SQL Server 2000. It has 9 databases, but only one is really hit to any great extent. There's another database that supports a new application that may be used heavily in the near future. We have two other servers that serve as a staging ground for the two above mentioned ones, and one server that we use for development. Each server has two disks. Unfortunately, that means that logs and data in some cases are on the same machine. But, is this all that important given the fact that we use a RAID array?

Here's my question...

I have to look at our setup in terms of performance and reliablility. At the low end we're looking at adding 4 new servers, 2 for production and 2 for the staging environment. One idea would take our biggest application and database, leave them on the existing servers and move everything else to the new servers.

At the high end (correct me if I'm wrong) there's adding a datacenter server, SQL Server Enterprise licences (we have Standard now), a create a cluster. I think that would be the most difficult and expensive solution.

So, what's in the middle? Are there other options?

Thanks
Pierre

#	Title
1	Load Balancing / Redundancy
2	IIS Load Balancing
3	Recommendations Terminal Server / …
4	Database Level Load Balancing
5	DHCP load balancing help
6	Network Load Balance cluster Failing t…