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
LVL 1
activateahsdAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL 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
MdlinnettCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cliff GaliherCommented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.