Links That Came Up In Discussion

Part of "How to Decipher CXPACKET Waits and Control Parallelism (4 hours)"

Erin Stellato discussing that parallelism in CHECKDB is Enterprise Only (note: this post was written before MAXDOP option was added to DBCC CHECKDB):


DOP columns are only available on sys.dm_exec_query_stats in SQL Server 2016+  :

Joey D’Antoni explains how forced plans work on AG Secondaries (spoiler: they don’t):