Wednesday, January 27, 2016

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.

No comments:

Post a Comment