Solved

Virtual Environment Guru question allocating resources / SQL Server

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
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:
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

896 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now