I have a virtualized SQL server 2017 with a single application.
It has 32 Gb ram and 16 processors.
The application has high CPU pattern, sometimes reaches the 100% during a few seconds.
When reaches 100% the machine gets stalled.
I’m thinking using resource governor to guarantee the CPU never reaches 100%
I need news from the ground; the good and less good about resource governor.