Recently we ran into a situation with one of our virtual servers that required me to investigate how to increase performance. We had a Hypervisor running Microsoft SQL 2008 and it was getting hit hard and chugging down at peak times. One of the things I was able to do was increase the CPUs to 8 despite the 4 CPU limit on Hyper-V servers running on Server 2008 Standard. Below is a video on how to do this.
I did a few other things to help resolve the issue we were having so increasing available cores was not the entire fix. I also built a Raid 10 configuration with 15k rpm drives and ensured that this was the only Hyper-V we had running on this particular hardware. We had 24gb of ram available and I gave 16gb to the Hyper-V. We had 16 available cores and I allocated 8 to the Hyper-V. I do believe however that setting the database server up on the Raid 10 configuration and optimizing the way IIS was hitting the SQL server had the greatest impact on the performance increase.
I'm a life-long computer geek who has worked in the field of computers since 1997. As a child, I spent much of my time writing basic programs on my Commodore Vic 20. My desire to understand how things work, along with my unwillingness to admit defeat, has made me a tenacious problem solver in all aspects of life. I maintain several websites and a YouTube channel http://youtube.com/NoGripes/
Thanks for stopping by!