Jonathans query only returns 8 queries.

OptimizationLvlSubTreeCostusecountssize_in_bytes

FULL250.4238131072

FULL11.585498673728

FULL909.892473728

FULL25.4864163840

FULL112.03424106496

FULL364.273561131072

FULL402.357308229376

FULL231.654594483328

Looks like I need to start tweaking.

Thinking MAXDOP 5, Threshold 10

Maybe a simple question, but how can I best measure the changes?

Can I make these changes during normal hours? (Doesn't matter if cached plans are cleared)