Solved

Virtual Environment Guru question allocating resources / SQL Server

Posted on 2013-11-07
4
414 Views
Last Modified: 2013-11-07
Hello all.

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.

Thanks
0
Comment
Question by:sbornstein2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
burdit earned 500 total points
ID: 39631703
Basically you are dealing with a scale 'up' or scale 'out' problem. In terms of VMWare we (the company I work for) are using the scale out approach. You can can allocate all the ram you want to your 5 servers but you will reach a cpu core cap and ram cap eventually. SQL licenses are per core, so setting up 20 vms 1 core each is the same price as 5 vms with 4 cores each.
Here is the VMWare best practices guide for SQL Server:
Best Practices SQL Server & VMWare
0
 

Author Comment

by:sbornstein2
ID: 39631774
So pardon my lack of knowledge here on the hardware side can you elaborate just a little more on the cpu core cap and ram.   So if SQL Server is installed lets say on one machine with 5 databases and it takes a heavy load many users banging on it with connections etc.   Then eventually is it a single processor when you say (core) that eventually will cap out?   Sorry again im a developer so clueless on the hardware networking side sometimes but a very good developer :).

I guess what I am trying to determine is the right way as far as performance to have seperate VM's each with a SQL Server instance versus the multiple on say the 5 VMs?   It would be multiple databases on a SQL instance so one license for that versus a seperate instance and one database for example.

Not sure im making sense hopefully lol.
0
 

Author Comment

by:sbornstein2
ID: 39631863
I guess I am understanding what your saying with the cores.  If I decide to run them on 4 VM's I would want more cores likes you said 4 cores per server and licensing is per core.  I got it.   Thanks
0
 

Author Closing Comment

by:sbornstein2
ID: 39631864
thanks a lot this was helpful.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question