hyper V CPU question

Basic Hyper V CPU question

Server 2 CPU 8 Cores each

I want to know a rough broad answer to how I should assign VCPUS in Hyper V. This is a simple scenario with no unexpected usage or complex requirements

For this scenario we will say 30 users that are using normal everyday functions. File Print, AD. There is an RDS server that is used for office apps users and a database by 10 of the 30 users. The database is low intensity with infrequent complicated queries that take 5 minutes to process. The database is run on an SQL 2016 Server that is its own VM. I am not going to bring Disks and Iops into this. I am familiar with how these should be done.

Server 1 2016 AD 8GB 2VCPU
Server 2 2016 Print server 8GB 2CPU
Server 3 2016 RDS 16GB 8VCPU
Server 4 2016 SQL 2016 32GB 8VCPU
Server 5 2016 VDI for a specific high performance user to run infrequent large excel queries 16GB 8VCPU

Does this look reasonable? My aim is to reasonably protect functions like print and AD while giving a large amount of CPU to DB and excel functions as required. The larger CPU draws are infrequent and it is important they are prioritised.
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:
I woikd probabky start with 2 vCPUs on all VMs then start performance tu ing based on incoming data.

Especially starting multiple VMs at 8, when each real CPU only has 8 cores, you could have unintended consequences of time sharing across processors and hurting performance.
Aaron TomoskyDirector of Solutions ConsultingCommented:
Definitely don't overprovision the vcpu to real cpu, 16 should be your max unless you have competing VMs at different times, and ideally hyperthreading to help. If you license sql by core, them you should give it 4 as that's the min, 2 to everything else and the rest to RDS to make 16.
for AD and print 2 VCPUs are more than enough, how many total users you have? 30?

for rest of all servers, you could be better off with 4 cores, since overall physical CPU seems much more powerful, it should be able to handle your virtual requirement with minimum cores assigned

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
 Acronis Global Cyber Summit 2019 in Miami

The Acronis Global Cyber Summit 2019 will be held at the Fontainebleau Miami Beach Resort on October 13–16, 2019, and it promises to be the must-attend event for IT infrastructure managers, CIOs, service providers, value-added resellers, ISVs, and developers.

DurgesAuthor Commented:
Most of the time the total cpu usage is very low. Maybe 10 - 15% max total between all VMs as you can see they are not doing very much. However when I do need them to do something they all max out at 10% of total cpu and take a long time to complete the task. I really want them to be able to take what they want when they want...  I cannot seem to get the ability to assign a larger piece of Cpu availability without giving more cores. Why shouldn't I over provision in this scenario? I understand if this was a very high load host and things were competing but they just are not competing.
what is disk used for this base server?

It is fibre channel storage?
it is 15K SAS disks?

it is 10K scsi disks?

the slowness caused by disks I believe since you  are saying that only 10% of overall physical CPU is utilized....

also what about assigned memory, is it paging out more? I mean check your memory allocation and monitor page file counter, if its going beyond 50% than assigned meory, you should add more memory..

yet we have not checked that part I believe
DurgesAuthor Commented:
Thanks for the help.
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
Windows Server 2016

From novice to tech pro — start learning today.