Timeline for VMware Socket/Core allocation for SQL Server 2016
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 8:59 | comment | added | Sir Swears-a-lot | Have a good look at what else is running on the same host. Ive experienced problems with having different sized VMs on the same hosts. | |
| May 18, 2017 at 17:37 | history | tweeted | twitter.com/StackDBAs/status/865260077707644928 | ||
| May 18, 2017 at 16:36 | answer | added | Tho H. Le | timeline score: 1 | |
| May 16, 2017 at 18:39 | comment | added | John Eisbrener |
Per the article you link to: ensure you mirror physical server’s NUMA topology. Start with mimicking the NUMA configuration of the physical processer. If it gets you to a core count of 16 (which looks to be your target), I would say that's your best base configuration. Obviously if testing proves the configuration needs adjustment, do so as it's one of the major benefits of running on top of a VM.
|
|
| May 16, 2017 at 17:40 | comment | added | Tho H. Le | VM: Windows 2012R2 Standard | 16 vCPU | 256GB RAM | SQL Server 2016 SP1 Enterprise Edition | |
| May 16, 2017 at 17:36 | comment | added | Erik Reasonable Rates Darling | Are you using Enterprise? | |
| May 16, 2017 at 17:30 | comment | added | Tho H. Le | I meant to say 2 socket BL460. SQL Server is licensed by the core. I am unsure about vmWare | |
| May 16, 2017 at 17:30 | comment | added | Tom V | Also what will be the memory configuration? You might want to ask about numa | |
| May 16, 2017 at 17:28 | comment | added | Tom V | How are you licensed? What version is it? Is it core or socket based? | |
| May 16, 2017 at 17:24 | review | First posts | |||
| May 16, 2017 at 18:49 | |||||
| May 16, 2017 at 17:21 | comment | added | Tho H. Le | Hi Tara, thanks for the response. What would I ask our infrastructure team specifically? I know the VM Host resides on a BL460 with 2 physical cores. | |
| May 16, 2017 at 17:10 | comment | added | Tara Kizer | Need to know how the host is configured. You don't want to create a wide VM. | |
| May 16, 2017 at 17:07 | history | asked | Tho H. Le | CC BY-SA 3.0 |