Say I run a server side trace against a SQL Server 2008 R2 instance, which has
Maxdop = 1 in place, then I run the trace through
readtrace.exe to get RML files for replay.
Does the replay preserve the instance-level setting of
Maxdop =1 such that none of the queries will run parallel on a
maxdop = 0 server?
When I look at my trace, I see lots of events called 'Degree of Parallelism' with '1 - Select' in the EventSubClass. Does this force
maxdop = 1 for the queries when they are replayed against a different instance?