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
cluster and 2 sql instance cluster?
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
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:2E64C5E8-A0BB-41AB-8174-FF26137A1F17@.microsoft.com...
> 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
> cluster and 2 sql instance cluster?
sqlsql
No comments:
Post a Comment