asked on

Setting up an SQL Server Cluster/Farm?

Hello, I plan to purchase and setup Microsoft SQL Server 2008 across multiple machines. When I worked at MS, they had a server farm setup (that I used, but did not setup) that was a collection of numerous machines, forming one SQL Server. I'd like to know what versions of 2008 Server, and SQL Server 2008 I need to get to do this (as there are numerous forms of it ranging from 500 to 5000 dollars).

Then what is the overview of configuration/installation options required to set it up, (also leaving it open to add more servers over time.)

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dan Violet Sagmiller (He/Him)

ASKER

We had this up and running internally, but I guess that doesn't mean that it works externally... grumble. I think I'll wait for a little bit hoping that someone has a solution that can work through a single connection, or round robin connection array. (but still only sending the command to a one server, and that takes care of everything. I don't want redundancy, I want parallel)

SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dan Violet Sagmiller (He/Him)

ASKER

Unfortunately, (grumble) I know what you mean. I guess this is what is needed. It bothers me that with as much work with shared processing as there is, that databases haven't evolved with it. At least not on that scale.

I was hoping for a good answer, but I have to accept truth. Thanks. :)

chapmandew

I know what you mean. I think** Oracle adds a layer so that it looks like the db is clustered in such a way, but it just handles the abstraction for you.

There may be some 3rd party software kits out there that handle it for you....not sure though. Its somewhat of a complicated beast.