Hi all,

I've a SQL Server 2014 Enterprise Edition with resource governor active. I have created 3 resource pool:

GOLD

SILVER

BRONZE

and one workload group for each resource pool. 

I'm observing high CPU usage on my SQL Server machine and I wonder why the resource governor seems to not capping CPU usage as I have set.

This is the CAP_CPU_PERCENT of my resource pool:

ALTER RESOURCE POOL GOLD
WITH(       
     CAP_CPU_PERCENT = 20
);

ALTER RESOURCE POOL SILVER
WITH(       
     CAP_CPU_PERCENT = 10
);

ALTER RESOURCE POOL BRONZE
WITH(       
     CAP_CPU_PERCENT = 5
);

ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

And the most weir thing is that I see very few Process running:

Are you consistently noticing high CPU or just some spikes. According to https://msdn.microsoft.com/en-us/library/bb934024.aspx, due to the statistical nature of CPU governance, you may notice occasional spikes exceeding the value specified in CAP_CPU_PERCENT. Did you make sure system processes (SPID # < 50) like lazy writer, etc were not consuming any CPU as these system processes using the "internal" resource pool and may be contributing to the spike.

I would like to add, that you may want to use Performance Monitor (Perfmon) in order to monitor CPU usage % and -control effect of the respective Resource Pools to gain a better understanding of the throttling effects. (Object: SQL Server: Resource Pool Stats) As said before though, short spikes can still occur.