This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

SQL Server Clustering

Question
0

Sign in to vote
Please let me know the differences and the relation between

A SQL Server Cluster,

Node

and an Instance

Knowledge is power.Information is wealth.
- Moved by Kyle Wang - MSFTMicrosoft contingent staff Wednesday, October 14, 2020 7:44 AM
Wednesday, October 7, 2020 11:08 AM

All replies

0

Sign in to vote
Clustering is a Windows OS feature, SQL Server is only cluster-ware application.

A node is a machine part of the cluster; a cluster can have 2-n nodes. Common are 2 nodes; an active and a passive node.

SQL Server instances has nothing (directly) to do with clustering. On one machine you can install up to 50 named, independent SQL Server instances, see Database Engine Instances (SQL Server)

BTW, SQL Server related forums moved to Question & Answer at https://docs.microsoft.com/en-us/answers/products/sql-server

Olaf Helper

[ Blog] [ Xing] [ MVP]
- Edited by Olaf HelperMVP Wednesday, October 7, 2020 12:08 PM
- Proposed as answer by Daniel_Zhang-MSFTMicrosoft contingent staff Thursday, October 8, 2020 1:08 AM
Wednesday, October 7, 2020 12:05 PM