Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Virtual Environment Guru question allocating resources / SQL Server

Posted on 2013-11-07
4
Medium Priority
?
416 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 2000 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

Cyber Threats to Small Businesses (Part 2)

The evolving cybersecurity landscape presents SMBs with a host of new threats to their clients, their data, and their bottom line. In part 2 of this blog series, learn three quick processes Webroot’s CISO, Gary Hayslip, recommends to help small businesses beat modern threats.

Question has a verified solution.

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

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…
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
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:
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

618 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