Jacob Wilkins (2/27/2014)
Another important thing to note is that the max_cpu_percent very, very rarely actually limits anything to that percentage. In SQL Server 2012 they introduced the additional cap_cpu_percent, which is a hard cap that actually does what you expect.I understand the desire to have limit that only applies when the server is under load, like max_cpu_percent, but I haven't found it to be all that reliable. The cap_cpu_percent in 2012, on the other hand, works like a charm.
Cheers!
Great suggestion! I will try. Thanks again