Best Practice - SQL 2012 & IIS in VMWare
Posted
by
Dan Ribar
on Server Fault
See other posts from Server Fault
or by Dan Ribar
Published on 2012-09-12T12:56:29Z
Indexed on
2012/09/16
21:41 UTC
Read the original article
Hit count: 275
sql-server-2012
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?
© Server Fault or respective owner