We have a SQL Server machine with 8 vCPU and 32gb of ram. Looking in monitoring tool, the average consume of CPU is only 1% last and current month. The customer wants to reduce the amount of vCPU and memory. How can we check the needed cpu and memory for this SQL Server? is there some metric inside SQL Server that suggest the amount of CPU and memory for the current workload?

Some facts:

Server is virtualized. It has 8 vCPUs and 32gb of ram. The CPU average is 1%. For SQL Server, the memory dedicated is 24gb. But it seems consume about 12gb (looking at the service in Windows task manager).

It seems is over dimensioned, mainly the amount of vCPUs. We need to reduce, it but I am not sure how much to keep.

  • 1
    You wrote about average. But do you have spikes? It is a production server?
    – user_0
    Aug 5 at 11:56
  • About virtualization: it is on prem with VMWare, Hyperv,ecc.. or in cloud?
    – user_0
    Aug 5 at 11:57


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.