Best Practice - SQL 2012 & IIS in VMWare
- by Dan Ribar
We are pretty new to VMWare and looking for some thoughts on our environment.
We have a VMWare cluster that has on one host:
VM#1: MS Windows 2008 R2 Enterprise & SQL Server 2012
VM#2: MS Windows 2008 R2 Standard & IIS
The IIS asp.net app talks directly to the SQL Server. We had this similar environment on physical servers a few months ago and just recently moved to the virtualized environment.
Regarding the setup, we have not tweaked any of the vm resource parameters -- all is set as standard and all is working.
What is observed is that the VMs seem to spool down and we get lags in response. Of course this sin't as fast as the old physical environment, but I am wondering if:
*is it a good idea to run the SQL server and the IIS server on the same host? They are the only two VMs on it. The host is a new Dell R620 with 192 gb mem.
does it make sense to change any CPU or memory reservations when it doesn't seem like there is any contention
is there a way to keep the VMs spooled up to eliminate delays?
This is a brand new squeaky clean vanilla install.
What are your thoughts?