Avatar of Akulsh
Akulsh
Flag for India asked on

MS SQL cluster - How many Instances? And what entails?

We have a recently installed MS SQL 2012 cluster.
- How many more instances can be added to it?
- Does each instance requires a separate SQL license?
- How many separate SAN drives will we need for each instance? Currently we have: 1. database 2. log 3. TempDB 4. Backup. Perhaps Backup drive can remain same, but what about TempDB drive? It seems, minimum two new SAN disks be needed?

Thanks.

AjayK
Microsoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott Pletcher

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Akulsh

ASKER
Scott,

Thanks for replying.
Since it is a SQL cluster which requires enterprise license, we are of course using it.

So we can add 3 more instances easily. Is there any Microsoft link that affirms this? Thanks.

Ajay
Scott Pletcher

Here's some official MS text on this:
"
With the SQL Server 2014 Enterprise Edition, when you have licensed all physical cores on the server, you can run an unlimited number of instances of the software in a number of OSEs (physical and/or virtual) equal to the number of core licenses assigned to the server. For example, a two-processor server with two cores per processor—fully licensed with eight core licenses (assuming a core factor of 2 in the SQL Server Core Factor Table)—could run SQL Server software in up to eight virtual machines, regardless of the number of virtual cores allocated to each virtual machine.

With the addition of Software Assurance (Software Assurance) coverage for all Enterprise Edition core licenses (when the server is fully licensed), your use rights are expanded, allowing you to run any number of instances of the software in any number of OSEs (physical or virtual). This enables you to deploy an unlimited number of virtual machines to handle dynamic workloads and fully utilize hardware computing capacity. Note: This benefit ends when Software Assurance coverage expires.
"
Akulsh

ASKER
I presume it also applies to SQL 2012 enterprise. Thanks.

Ajay
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Scott Pletcher

I believe it does.  To 2012, but not before that.