Links That Came Up In Discussion

Erin Stellato discussing that parallelism in CHECKDB is Enterprise Only (note: this post was written before MAXDOP option was added to DBCC CHECKDB): https://www.sqlskills.com/blogs/erin/dbcc-checkdb-parallel-checks-and-sql-server-edition/

DBCC CHECKDB docs: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql

DOP columns are only available on sys.dm_exec_query_stats in SQL Server 2016+  : https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql

Joey D’Antoni explains how forced plans work on AG Secondaries (spoiler: they don’t):  https://joeydantoni.com/2017/02/17/query-store-and-availability-groups-force-plan-on-secondary-replicas/

Back to: How To Decipher CXPACKET Waits and Control Parallelism (4 hours) > Topic 6

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu