Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

SQL Server in CLuster

Locked

Hi

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

Topic

Reply To: SQL Server in CLuster

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:
http://www.microsoft.com/windows2000/technologies/clustering/default.mspx

Job Cacka

Reply To: SQL Server in CLuster

In reply to SQL Server in CLuster

Yes clustering can be simulated.
I recommend using Microsoft Virtual Server 2005 as detailed in this tutorial. http://www.sql-server-performance.com/installing_sql_clustering_virtual_server1.asp
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.

[Author]

Replies