Solved

Virtual Environment Guru question allocating resources / SQL Server

Posted on 2013-11-07
4
412 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

749 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