SQL on 2012 VM

Hi,
I have a physical 2012 R2 server with one VM running on it currently (2012 R2 Domain Controller), i want to add a second VM, this one will be 2012 R2 with SQL Server 2012 for running the accounting program Exchequer.
The server has 64Gb of ram so there should be more than enough according to the spec requirements. I have a couple of questions, firstly, please can I confirm that licensing for the 2nd 2012 R2 OS is covered by the original host license (as long as no added services are running on the host)? Secondly, are there any special considerations for running SQL on a VM or is it just a case of installing as if it were a stand alone physical server?
Many thanks
Andrew
activateahsdAsked:
Who is Participating?
 
MdlinnettConnect With a Mentor Commented:
Check out the attached PDF from Microsoft.

The main thing is to make sure that you do give it plenty of resource that isn't necessarily shared between other Servers.

Storage is a key factor, not on size but on speed, RAID 10 or RAID 6 storage will be best.

If you can, dedicate a NIC to just that VM. So create a separate Virtual Switch and, within the Virtual Switch Manager, untick the 'Allow Management Operating System to Share this Network Adapter' tick box for that new Virtual Switch.
best_practices_for_virtualizing_and_.pdf
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
are there any special considerations for running SQL on a VM or is it just a case of installing as if it were a stand alone physical server?
Correct. Just installed it. SQL Server doesn't care if it's a physical or virtual server. It just want to know if he have the necessary resources (CPU, RAM, Storage and Network). Guarantee that and you won't have any trouble with SQL Server.
0
 
Cliff GaliherConnect With a Mentor Commented:
2012 R2 Standard does allow two VMs in a single 2-CPU server. You weren't specific on what edition of 2012 R2 you had, so whether you ae okay from a licensing standpoint is unknown.

As to the second part of your question, there are no "special" considerations. But all of the considerations for installing SQL on a physical server still apply. I/O, memory, network utilization all need to be planned and accounted for, and different programs stress SQL in different ways. There is no universal "do this." Your application vendor should be able to assist.
1
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Megan BrooksSQL Server ConsultantCommented:
It's been a while and you would need to confirm this elsewhere, but I dealt with with SQL 2012 Enterprise licensing when the product first came out and what I recall is that if we had enough licenses to cover all of the physical cores on the VM host then we could run multiple VMs on it as needed. Otherwise the VMs had to be licensed. I've not worked with 2012 Standard.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
is that if we had enough licenses to cover all of the physical cores on the VM host then we could run multiple VMs on it as needed. Otherwise the VMs had to be licensed. I've not worked with 2012 Standard.
As far I recall it was 4 Enterprise licenses for physical CPU so if you want to spend it with a Standard Edition you are just burning one Enterprise license.
0
 
Megan BrooksSQL Server ConsultantCommented:
It's too far back in Internet time for me to remember clearly, but it seems like we needed one Enterprise license per two cores. I can't believe that was only a few years ago -- it feels like decades.
0
All Courses

From novice to tech pro — start learning today.