I was looking at my client's UAT farm and found out that MAXDOP was set to 0 on SQL Server instance hosting SP databases. Before setting this value to 1, I measured response times of most commonly viewed pages along with heaviest pages.
To my surprise, after setting MAXDOP to 1 and restarting SQL Server service, performance was decreased. One heavy page was loading in 4.5 seconds before change, and 4.8 seconds after change. This was measured multiple times.
Did anyone experience a similar issue and how did you resolve it?