How to Leverage Parallelism in SQL Server

SQL Server has the ability to generate parallel execution plans, which take advantage of multiple cores and execute queries in parallel. 

There are two settings that highly affect the efficiency of this parallelism. We are talking about Max Degree of Parallelism (MAXDOP) and Cost Threshold for Parallelism (CTFP). 

Unfortunately, the default values for these settings are not optimal for most workloads.

Join this webinar to learn from Vitaly Bruk, how to properly configure these settings for your workload. 

By following Vitaly's recommendations, you might experience significant performance improvement.