how many allowed instance for SQL server 2012 standard edition?

Dear all

I need to install another instance on my server and i need to know the number of allowed instance to be used under my license for SQL server 2012 Standard edition.

I am licensed for 8 cores but I don't know the number of instances I can install!

thanks and best regards

August 23rd, 2015 5:57am

To my knowledge there is no limit to the number of instances on a single server. 
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 10:19am

Dear all

I need to install another instance on my server and i need to know the number of allowed instance to be used under my license for SQL server 2012 Standard edition.

I am licensed for 8 cores but I don't know the number of instances I can install!

thanks and best regards

Hi,

License limit is not for instance that can be installed on one server. You have limitation which is documented here  and that is 32767.

August 23rd, 2015 10:58am

Hi,

John is correct and there should be no limit to number of Instance.

Read

Consequently, an obvious way around this problem is to use multiple, named, instances on the same server. In doing so youll need to potentially constrain access to processors (i.e., set affinity typically to distinct NUMA nodes for best results) and watch out for situations where you might run into IO contention, but, otherwise, the use of multiple instances CAN be one way to get the most bang for your buck out of SQL Server Standard Edition licenses provided youre willing to babysit and tune your workloads as necessary.

and further check

http://sqlmag.com/blog/sql-server-standard-edition-licensing-limits

Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 11:13am

You do not need to buy a new license for adding new instances to an already licensed Server but there is a restriction on the number of instances that can be created which is as below:

50 instances on a stand-alone server.

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.

https://msdn.microsoft.com/en-us/library/ms143432.aspx


August 23rd, 2015 11:40am

AFAIK, if you are on a VM, you need one license per instance. If you are physical, you can have x (50 supported and tested) on the same license. But don't take my work for it, Rad the license paper that has already been posted here.
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 1:44pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics