Is there any documentation, test data, or other evidence to suggest that the Cost Threshold for Parallelism (CTP) setting might impact performance when TDE is enabled on a database? Without going into all of the details, we have seen some significant performance degradation with benchmark tests after enabling TDE on a database, and we are looking for any settings that might have an impact. CTP is currently set to the default of 5, which I know is not ideal, so please resist the urge chastise me for it.
We will also add CPUs and test further, but if we can get better performance by changing CTP or another setting, that would of course be better than adding CPUs (due to the cost of the hardware, as well as SQL Server licensing per CPU).
I am pushing to change the CTP and test again, but I was hoping to see if anyone has already tested it so that we can prioritize the changes we want to test accordingly.