Solved

Virtual Environment Guru question allocating resources / SQL Server

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
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:
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now