I'm wondering what people's experiences are with tuning performance of the SQL Server back-end?
We use SQL 2012 on an 8-core CPU VM. I have MAXDOP set to 8, and threshold to 50. I haven't noticed much difference raising or lowering MAXDOP, or even raising or lower the threshold. Most queries and reports just seem to use 1 thread.
I'd be interested to hear what other people have as their settings, and if they've found any that make any noticeable difference?