We are Virtualizing the SQL Servers in W2k8 by using *HyperV*. I have 7 Virtual Servers and assigned 4GB Memory for each VM at the moment. But main Server has 32GB Memory so that it shows 32 GB in Maximum Server Memory when I log into any VM
machine.So it look like SQL Server I have installed on each VM is using Memory from the Main Server, not from the local VM machine I setup with 4GB? Normally, I set the Max Memory for all of my production server (*Total Memory - 2GB for Operating System*). Do I still need to apply for VM as well? Assign Max memory to 3 GB?
Also that might be completely diffient question - according from ***Microsfot*** and ***BOL***, it said creating the Multiple *TempDB* will get a better performance of the system. Let say I have 4 processors with 4 core so that I should create 16 TempDB to get better performance?