I have recently done a P to V migration on a SQL server for one of my customers. They are now saying they have slow read and write access to the SQL data base. They access it Via a client installed on the work station. It is running on Hyper-v (Gen 1 as it would not migrate to Gen 2)
I have already gone down the path of disabling the virtual machine Que on the network cards. The CPU and Ram usage never gets above around 25% usage.
The hyper-v server, is running two 10 core hyper threaded CPU, 96 gb of Ram, 10X 1.2TB 10K sas drives in Raid 10 and 10GB network. So the speed of the Server should not be an issue.
The VM is set with 8 cores and 16gb of ram and a single VHD file.
Am I missing somthing?