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