I've heard in a presentation that the number of supported nodes in a cluster on 64bit system is going to be limited to 4. Can you confirm that?
What about the number of instances? These are the informations that I have:
25 in a cluster (a drive letter is required per cluster group)
50 in a standalone server with Enterprise Edition
16 on the other Edition
Can you confirm as well?
Thanks for your response.
JeromeSQL Server 2005 Enterprise Edition will support as many nodes as the underlying operating system supports .. which is 8 nodes in current versions of Windows (in the editions that support Server Clustering). So the maximum number of nodes is 8, and that's true for both 32-bit and 64-bit.
In SQL Server 2000 32-bit edition the limit is 4 nodes, but the 64-bit edition supports 8 nodes.
Your instance numbers are correct though your number of 25 on a cluster is likely too high: typically you have the drive letters A:, B:, C: already assigned to local drives, so that leaves 23 letters for the cluster groups, and for a shared quorum cluster one more drive letter (Q:?) will be needed for the quorum drive, so that leaves 22. So 22 clustered instances is a more realistic limit, though with an MNS (Majority Node Set) cluster where the quorum info is kept on the local drive of each node you could get 23 clustered instances.
Thanks,
Don|||The maximum instances I have seen on MS SQL 2005 is 16 instances on 4 nodes.sqlsql
No comments:
Post a Comment