Hyper-V best practices - page file, vCPU, partition, UPS software, backup, etc.

The host is a new Dell server PowerEdge T620 as below
Raid 0, 2x300GB
Raid 10, 10x600GB
Dual Xeon CPUs 2x E5-2660 v2
Host OS: Windows 2012 R2 STD

I will need to configure 2 VMs at this moment, and 1 or 2 more in the future.
- SBS2011 STD
- SQL2008 R2

There are about 60 users.

I would need some best practices to configure the followings
- Page File
For both host and VM
- Virtual processors for VMs
- Hard disk controller
- UPS software
I usually use APC PowerChute. Should I installed it on host only or install it on host and all VMs
- Backup
I usually use ShadowProtect. How is it doing with VM backup?
- VHD vs Partition
Should I assign one VHD to each VM with separated OS and Data partitions?
should I assign two VHDs corresponding to OS and Data to each VM?
should I assign one VHD to each VM with only one large partition?

I am sorry there are so many questions. Please help as you can.

Many thanks!!

Y YconsultantAsked:
Who is Participating?
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.

Cliff GaliherCommented:
For page files, leave sizes alone. Let windows handle then. Virtual or physical, you will always get better performance if you out then on a separate spindle though.

Processors: SQL has processor licensing limitations, so unless you've made alternate plans, you'll only be legally allowed to assign one virtual processor to that second VM.

VHD choices: Mainly this is about disaster recovery. I prefer OS on one, and data on a other, per VM. That's a personal preference though and not written in stone.
Y YconsultantAuthor Commented:
Our SQL license are per user not per CPU, so I guess I could as many vCPU as I want?
How will separated VHDs help disaster recovery?
Cliff GaliherCommented:
You can back up fast-changing data more often and slow-changing data less often for one thing. For another, in some disaster types that don't kill a machine, such as cryptolocker, restoring an entire data VHD is still faster and easier than restoring an entire OS, especially if that OS is a DC.

You might want to verify your SQL license. Unlike Windows, even user licensed SQL instances usually have processor limits. There were very few ways to license SQL any other way in the 2008 era of products.
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

David Johnson, CD, MVPOwnerCommented:
I use Veam for Hyper-V backups and DPM for the primary server.  UPS on the host only. Hyper-V is pretty good at stopping and starting VM's on server shutdown.  SQL backups (you can use a stored procedure to keep the log files manageable )
Y YconsultantAuthor Commented:
Our SQL Licenses are "Premium Addon" coming with SBS. I will look into it.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Don't use partitions, these are old fashioned, so create a VHD per disk you require, it makes them easier to manage, and easier re-size.

So if you require a C: drive, make sure this is "mapped" or created as one VHD.

The same with additional drives, D: make sure this is created as disk 2 (another VHD).

Best Practice for APC, is to use a Network Management Card in the APC Smart UPS, and then use APC free software...

see here


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
Y YconsultantAuthor Commented:
Thank you very much! Very helpful!
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

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.