This video is a follow up to CXPACKET video (Part 1). You will see that SQL Server Query Execution Engine still assign max number of threads (as per the number of cores (up to a max of 64)) even when the DB engine is under severe pressure.

Keywords: Parallelism, Wait Types, CXPACKET, Cost Threshold of Parallelism, MAXDOP

Important Links:

Follow SQLMaestros on Twitter

Click Here

Follow Amit Bansal on Twitter

Click Here

Subscribe To Newsletter

Click Here

SQLMaestros Video Courses

Click Here

SQLMaestros Hands-On-Labs

Click Here

Subscribe to Amit Bansal’s exclusive distribution list

Click Here

Join us on Telegram

Click Here

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter