General discussion


SQL Server in CLuster

By parth ·

I am trying to simulate a Cluster environment.
Following Hardware is used.
2 PCs and a NAS Box(windows 2003).

Will it be possible to simulate the Clustering?

Thanks in adavnce

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by jc2it In reply to SQL Server in CLuster

Sure, but remember that a cluster in Windows is for redundancy, and load balancing. In Unix it provides increased processor power (Beowulf Cluster).

For more info:

Job Cacka

Collapse -

by garciabe In reply to SQL Server in CLuster

Yes clustering can be simulated.
I recommend using Microsoft Virtual Server 2005 as detailed in this tutorial.
I'd recommend at least 128 MB of RAM allocated for each node in the SQL cluster to get some better load performance measurements.

I've done this in a lab environment using 2 machines with 4 nodes(virtual) for 2 different clusters successfully.
It (MS Virtual Server) is great for testing purposes but Microsoft nor I recommend it for production use.

Related Discussions

Related Forums