Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

SQL Server 2005 running under Hyper-V


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

1 Solution
Neil RussellTechnical Development LeadCommented:
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.
proximityworldAuthor Commented:
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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now