Virtual Environment Guru question allocating resources / SQL Server
Posted on 2013-11-07
Question so let's say hypothetically I have 20 customers and each customer has roughly 20K users for a web application that fronts to each SQL Server backend. It is very expensive to spin up 20 VM's with separate SQL server licenses. So in this case it would be 20 VM's with SQL Server for each customer. If I had for example 5 servers with 4 customer 'databases' on each server so now of course I increased my load possibly 80K users, with memory etc. does it make a difference cause it's going through the same hardware and I would in this case just need to allocate more RAM to each of the 5? Looking for a good answer on this as far as performance.