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.