Erik Darling explains why he is not a fan in this video on the topic.
Because there’s no text, I’ll hit on the points:
- It only tests degree of parallelism downgrades and does not test upgrades
- It only tests downgrades to DOP 2
- It doesn’t test upgrades from serial to parallel plans
Click through for the video. Erik also talks a bit about cost threshold for parallelism.