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):


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):

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.