I currently have a dedicated server that we have outgrown and we are moving to another server.
Our current setup was a 8gb W2008R2 server running a W2008R2 IIS virtual machine using VMWare.
We are moving to a 2 cpu 24 gb server with W2012 R2 on Hyper-V.
On our virtual machine we are running iis 7.5 and sql server. Sql Server seems to want to eat up all the memory so I had to cap it at 2gb, which doesn't seem sufficient.
My question is, when I move the virtual machine to the new server, should I create 2 virtual machines, one for sql server and one for IIS? Or should I leave them both on the same virtual machine? Or even, put the Sql Server on the dedicated server and run the IIS in the vm?
I'd like some input on how this should be done, I've not got the experience needed to make the right call.
Thanks!