Issue with CPU Affinity Configuration on a SQL Server VM with 30 vCPUs

• abdalah.mehdoini

  Ten Centuries

  Points: 1015

  More actions

  November 24, 2024 at 5:42 pm

  #4488494

  Hello ,

  I'm having an issue with a SQL Server VM that has 30 vCPUs allocated. However, in the server affinity configuration, when I check the "Affinity Mask", it detects only 19 vCPUs.

  Can someone explain to me why there is a difference between the number of vCPUs allocated to the VM and the number detected in the affinity configuration? Is this a configuration issue or is there a limitation of SQL Server or the VM itself

  

  Thank you for your help

  Thanks