yakko_Warner (11/25/2015)
which I'm sure is impacting performance do to storage not be the same setup as the physical box.
storage is generally the weak link, you wont get like for like performance between a physical disk and a virtual disk
yakko_Warner (11/25/2015)
They also didn't match the cores of the physical server in the virtual server.
there's no 1 to 1 relationship here either, if a server has 8 cores and you virtualise it you wouldn't generally give it 8 vCPUs, it doesn't work that way. The number of vCPUs just indicates a portion of the host CPU time.
yakko_Warner (11/25/2015)
But from what I have read the increase in CPU overhead b/c of TDE being enabled, which is what I was trying to say goes up depending on the workload of the server. The workload this server is seeing is having around 500 users connecting to it all day during business hours getting data ect.I am still very appreciative to all the thoughtful responses and I am learning all the time.
Thanks again!
Have a Happy Thanksgiving!
The increased CPU hit on a VM could well be causing issues, the restricted virtual disk performance will also be a factor
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉