I am using Brent Ozar’s sp_BlitzCache store procedure and I’m attempting to nail down why it is reporting:
“Something in your plan is forcing a serial query. Further
investigation is needed if this is not by design.”
Upon investigation I found that the server configuration has set:
'Max Degree of Parallelism = 1'
(That is on my laundry list to configure correctly. It is a hold over from days of ignorance.)
Is that setting the cause of Brent to report forced serialization?