SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal)

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.

Get new content directly in your inbox – Click here

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

Hope the video was worth your time.

Happy Learning.