May 27, 2015 at 8:31 am
Is there a limit to the number of 2 node instances you can install on a server using SQL Server Standard? I would like to install 2 - two instances of SQL SERVER STANDARD and have failover clustering. Do I need 1 server per instance or can both instances be installed on one server?
Architecture
Server 1
SQL_Instance_1
SQL_Instance_2
Server 2
SQL_Instance_1(Failover)
SQL_Instance_2(Failover)
Or
Server 1
SQL_Instance_1
Server 2
SQL_Instance_1(Failover)
Server 3
SQL_Instance_2
Server 4
SQL_Instance_2(Failover)
May 27, 2015 at 9:38 am
you may install 2 clustered instances using Standard edition onto a 2 node cluster like so
Server 1
SQL_Instance_1
SQL_Instance_2
Server 2
SQL_Instance_1(Failover)
SQL_Instance_2(Failover)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 2:12 pm
I think Perry's answer is perfect. As far as the maximums for instances all editions of SQL Server support up to 50 instances on a single machine.
Features Supported by the Editions of SQL Server 2014
Joie Andrew
"Since 1982"
May 29, 2015 at 12:25 am
Joie Andrew (5/27/2015)
I think Perry's answer is perfect. As far as the maximums for instances all editions of SQL Server support up to 50 instances on a single machine.
SQL Server supports 25 instances on a failover cluster when using a shared cluster disk as the stored option for you cluster installation SQL Server supports 50 instances on a failover cluster if you choose SMB file shares as the storage option for your cluster installation
... from the same link you posted.
May 29, 2015 at 2:25 am
SQL Server supports 25 instances on a failover cluster when using a shared cluster disk as the stored option for you cluster installation SQL Server supports 50 instances on a failover cluster if you choose SMB file shares as the storage option for your cluster installation
That is interesting. I could not find that information on the SQL Server 2008 R2/2012/2014 versions of that article. I saw it on the SQL Server 2008 version of the article, but not the newer ones. Where did you see it?
Joie Andrew
"Since 1982"
May 29, 2015 at 4:06 am
Sorry Andrew. It was not the link you provided.
I was checking the below link
https://technet.microsoft.com/en-us/library/ms143432(v=sql.110).aspx
Sorry for the confusion.
Thanks,
San.
May 29, 2015 at 5:25 am
No worries. I am glad for the clarification. I hope MS updates the BOL articles to reflect. I am not sure how much of an edge case that would be, but I would hate to be the person pushing for something based on one archiecture limit only to find out it could be a more restrictive one.
Joie Andrew
"Since 1982"
May 29, 2015 at 8:33 am
Joie Andrew (5/29/2015)
No worries. I am glad for the clarification. I hope MS updates the BOL articles to reflect. I am not sure how much of an edge case that would be, but I would hate to be the person pushing for something based on one archiecture limit only to find out it could be a more restrictive one.
Indeed! Of course, on the subject of being hypothetical people, I don't think I can quite articulate my feelings about being the person supporting 50 instances on a failover cluster :Whistling:
Cheers!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply