It's Time to Get Rid of the Cost Threshold for Parallelism Setting.

Description:
In this video, I delve into the complexities of the cost threshold for parallelism setting in SQL Server and why it's time to get rid of it. This setting has long been a source of confusion and frustration, as many believe there is an optimal value that can be set to ensure queries run efficiently. However, I argue that this approach is fundamentally flawed because the cost threshold is a unitless metric that doesn't accurately reflect how modern workloads should execute. Instead, I emphasize that query tuning goals should focus on making queries run faster rather than reducing estimated costs, which are merely pre-execution estimates and not actual execution times.

CHAPTERS

00:00:00 - Introduction
00:00:29 - Cost Threshold for Parallelism
00:02:59 - Max Degree of Parallelism
00:03:53 - Estimated Costs vs Actual Costs
00:06:14 - Control Illusion
00:08:41 - Batch Mode on Rowstore
00:10:19 - Future Improvements
00:11:27 - Conclusion

━━━━━━━━━━━━━━━━━━━━━━━━━━
???? TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING

Learn T-SQL with Erik
https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL

Everything Bundle:
https://training.erikdarling.com/?coupon=SPRINGCLEANING

━━━━━━━━━━━━━━━━━━━━━━━━━━
????️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting

━━━━━━━━━━━━━━━━━━━━━━━━━━
???? CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
https://www.youtube.com/@ErikDarlingData/join
━━━━━━━━━━━━━━━━━━━━━━━━━━