Increase vCPU or Core ? RRS feed

  • Question

  • Hi all,

    I'm getting 96% CPU usage and 93% memory usage on my server which runs SQL 2014 and excel cube for reporting. The current configuration on the server is  2.66Ghz CPU and 16GB Memory with 2 vCPU and 1 Core per socket. I was wondering which to upgrade to make it run smooth with minimum cost. Do i increase Core, vCPU or memory? (i guess SQL will always utilize 90% memory regardless of the memory size.)

    Thursday, August 2, 2018 1:18 PM