March 2, 2017 at 11:46 am
Does anyone know of anyone, anywhere, that is running a production SQL server on a VMware Guest with 1CPU/1Core and 4GB of RAM?
I keep hearing the mantra of "right-sizing" and how bad it is to do over-provisioning, but it seems to me that even the most basic application needs at LEAST two cores to operate efficiently. This is regardless of the fact that there appear to be no CPU bottlenecks. My understanding is that there are certain tasks (index rebuilds, seeks, joins, etc. for example) that scream out for parallelism.
Any suggestions on how to get this point across would be greatly appreciated!
Thanks!
March 2, 2017 at 12:01 pm
I've had instances set like this in production. Often these were older (SQL 2000/2005) instances with little load.
Size to your workload. If this is the default new VM from your company, question whether that makes sense for a SQL Server, but I wouldn't necessarily assume this is bad. It always depends.
March 3, 2017 at 5:18 am
if an application to be installed within the virtual server uses SMp then at least 2 vcpu shares should be granted.
SQL Server is an SMP application
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2017 at 8:07 am
I'm on an estate where we have ten single-core servers, some with as little as 1GB RAM, and none with more than 8GB... They are, though, "sized to the workload" - they're not at all busy, but doing their own little thing.
In an ideal world, they would be consolidated (not necessarily with each other, but with other servers), but there are various political reasons why we're not allowed to do that. Yet.
Thomas Rushton
blog: https://thelonedba.wordpress.com
March 3, 2017 at 8:12 am
Always ask yourself, how many people do I need to transport how far, with how much fuel, in a 1 cylinder vehicle.
If your expectations are realistic, as well as requirements, I don't see why not. 🙂
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2017 at 8:49 am
The company I work for has 2000+ retail store locations, each running a local instance of SQL Server Express Edition to support their point of sale. That's production. We also have some applications like timesheets hosted on Azure Basic Tier where there is no guarantee of how many CPU at any given moment. It can fluctuate between 1 - 2.
... Any suggestions on how to get this point across would be greatly appreciated! ...
You'll need to do some load testing to prove whether a 1 CPU server can handle this specific application in production.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply