Sql server performing slow after changing the Cost Threshold for parallelism
We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server. Ironically in such cases we observe that sql server is performing slow even when there is no high CPU utilization and no high I/O operations on the server….