Sample Header Ad - 728x90

Design Sql Server physical configuration from existing VM

0 votes
1 answer
152 views
We have 4 virtual machines that we used to test our BI platform (PoC), the final dimensions are: - SSIS (16 vcpu), SSAS (8 vCPU), SSRS (4 VCPU) et Data Engine (24 vCPU) What are the recommendations to install these components to a physical server? For SQL Server performance, [VMware recommends](https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf#page=23&zoom=100,0,0) (chap. 3.5.2) setting the number of cores per socket to one when allocating virtual CPUs to VMs on the vSphere platform". That means that a VM with 16 CPUs will have 16 vCPUs with 1 core each. Can we calculate physical server dimensions using reverse engineering? I mean: 16 vCPU equals 16 physical core? The dimensions CPU and RAM of these VM are big so we are asking if it's not more interesting to deploy on physical machines. We need 280 GB of RAM. The same thing that VMware said here the ratio 1:1 or 1:2 is considered for more performance.
Asked by Benn (1 rep)
Apr 10, 2020, 02:45 PM
Last activity: Apr 12, 2020, 08:37 AM