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

Filed under:

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

Related posts about sql-server-2012