I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.
There are so many options you should experiment before you opt for query hint. Recently DBA asked me how to use query hint ENABLE_PARALLEL_PLAN_PREFERENCE.
I eventually expressed them it is possible to detect CPU pressure with Wait Statistics. We explained to them my method during the Health Check.
I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.