Posted on Leave a comment

Cost Threshold for Parallelism

Was experiencing high CPU usage (95%+) on 4 vCPU server I had “inherited”.
Server has SQL Server, Reporting Services, and Integration Services running on it.
Cost Threshold for Parallelism was set to 25.  Increased it to 120 and immediately saw drop in CPU contention.

Average CPU usage dropped to %25-%30 with short lived spikes instead long running contention.

Lowered to 60 and saw this:

Increased in steps of 10 up to 100 until the contention was again relieved.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.