Forum Discussion

marvsph's avatar
marvsph
Copper Contributor
Sep 14, 2019
Solved

Microsoft SQL Server 2008 R2 - Processor Affinity

Greetings! I am currently testing a banking system. Unfortunately, I looked unto the Live Optics result of the VM (as shown in the picture) and found out that the instance is only using 1 core o...
processor
Server 2008 R2
Server-Side
  • maxrem's avatar
    maxrem
    Sep 16, 2019

    same problem on vmware

    SQL SERVER 2016 SP2 CU8 + WIN SERVER 2012 R2 8 cores

    solve by manually check affinity on all cores

joseviado's avatar
joseviado
Copper Contributor
Sep 16, 2019
i also encounter the same problem. any recommendation?

Resources