cluster hardware - CPU, memory -- sql server clustering

Pari
6/22/2005 7:57:16 AM

1. In MSCS and SQL Server 2-node clustering on windows 2000 advance server,
are there any restrictions on the hardware. That is, do the 2 nodes
necessarily should have the same number of CPU and memory?

2. when we have 2 node with sql server in cluster, can we install another
non-clustered instance on the same server?

3. is there a link which describes the difference between 1 sql instance

Geoff N. Hiten
6/22/2005 11:31:23 AM

1). Certified cluster configurations must be symmetrical. That is all
nodes indentical. It is possible to run asymmetrical clusters, but they are
often more trouble and less reliable than a stand-alone SQL instance.
2). Yes.
3). The Microsoft SQL Server 2000 Resource Kit has some good information on
clustering, including using more than 2 nodes and multi-instance support.
BOL also has some basic information.

Geoff N. Hiten
Microsoft SQL Server MVP

[quoted text, click to view]

sql server clustering : cluster hardware - CPU, memory