Solved

SQL 2008 R2 Installation on Hyper-V VM

Posted on 2016-09-15
2
67 Views
Last Modified: 2016-09-19
Good day,

I need to create Windows 2008 R2 Server VM on a Hyper-V cluster with high availability. I then need to install SQL 2008 R2 on this server. I was wondering if someone can provide me an installation guide installing SQL on a VM.

I want to make sure I do not have performance issues.

Thanks.
0
Comment
Question by:Jacquesdl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
Russ Suter earned 500 total points
ID: 41799963
I use pretty much nothing but VMs at my office. There's no special magic or ritual you need to go through to install SQL Server on a virtual machine. It's as routine as installing it on any machine. What you need to do is make sure the VM has enough resources allocated (RAM, CPU cores, disk space). The great thing about a VM is that you can always allocate more resources later on if you need to. The one exception to this is you should make sure before you install that you have enough CPU cores allocated to the VM as are required to fulfill your license. SQL Core licensing always comes in pairs so 2 cores, 4, 6, 8, etc...
0
 

Author Comment

by:Jacquesdl
ID: 41804389
Thank yoou very much
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
Optimized for private cloud infrastructures and datacenters, Nano Server is minimalistic, yet super-efficient, OS for services such as Hyper-V and Hyper-V cluster. Learn how you can easily deploy Nano Server and unlock its power!
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question