SQL Server 2005 running under Hyper-V

Posted on 2009-12-27
Last Modified: 2013-11-06

I am thinking of setting up our new SQL 2005 server and using Hyper-V. It is a new HR system and they don't support SQL 2008.

Does anyone have any tips for using SQL under Hyper-V. The server itself won't be under a heavy load at all. Just 3 people in HR will be using it.

Any tips would be most welcome.

Best wishes

Question by:proximityworld
    LVL 37

    Expert Comment

    At least 2 processors to the VM, 4 preferable and a good amount of memory. This of ceourse depends on what OS you are running it under.
    LVL 1

    Author Comment

    Hi Neilsr,

    We will install SQL 2005 on Windows 2008 x64, if SQL 2005 like being on x64 if not, then it will be x32. I was more concerned about virtual disks. Would you make them a fixed size or not use virtual disks at all?

    Best wishes

    LVL 5

    Accepted Solution

    With Hyper-V R2 you can pretty much expect dynamic VHD's to get about 85% of normal. Quite a bit less if you are using Hyper-V SP2. Fixed size will get you better but with only 3 people under small load it really doesn't mattter much. I prefer dynamic as they are so much easier to work with and leave a small footprint only expanding over time.

    Stick with 64 bit if at all possible.

    Keep in mind one thing. When you build it they will come. Expect the VM to be used more over the next 3-5 years. You'll probably add more DB's to it as you will find it works great for those vendors who don't support 2008 yet. You then mearly add number of host CPU's and memory as needed and expand the disk if necessary. You can always create another drive of fixed disk or even present IScsi to the guest later on


    Featured Post

    Do email signature updates give you a headache?

    Do you feel like all of your time is spent managing email signatures? Too busy to visit every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

    Join & Write a Comment

    Nowadays, Virtual Machines are used equally by small and large scale organizations. However the issue is that VMDK files are also prone to corruption. So, in this article we are looking at how to recover VMDK files from hard disk of host operating s…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now