I have the following Virtual SQL Server (running in Windows Server 2016 Hypver-V environment): The VM is on one specific host shared with other vm’s and can be moved around on other hosts.
SQL Version: Microsoft SQL Server 2014 – 12.0.2269.0 (X64) Jun 10 2015 03:35:45 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 14393: ) (Hypervisor)
My VM has the following specs: 1 virtual Socket 8 Virtual Processors 500 GB SQL DB
The dev’s are breaking my bowling balls as they mention that the app in production is too slow because we are not allocating enough resources VM-wise.
However, I thought that 8 Virtual Procesors is the maximum no? I found a PDF on the following URL: https://download.microsoft.com/download/B/4/E/B4E604D9-9D38-4BBA-A927-56E4C872E41C/SQL_Server_2014_Licensing_Guide.pdf
but this looks so psychedelic that I can’t even understand half of what’s written.
Is there a table somewhere for noob system admins on max specs wise you can give to virtualized SQL Servers?