CPU Statistics in Resource Reports – what does it mean ?

by Apr 30, 2014

Hi, we have 2 active instances running on one node of a sql cluster which contains 80 cores and I’m trying to gather the CPU statistics to do some capacity planning. We have not affinitised CPUs to instances.
How do I intepret from this report the actual CPU usage for the instances ?
Eg for instance 1 – I can see cpu usage over a 1 month period to be around 20%. But is this 20% of the 80% at 100% utilisation or 20% of the assigned cores to that instance ? And if it’s the later, this report doesn’t show how many cpus are being used by the instance.

Any feedback will be appreciated!

Thanks