SQL Performance tuning for the SLM8/SI5 backend

Discussion created by RickTalbot Advocate on Mar 24, 2018
Latest reply on Mar 26, 2018 by RickTalbot

Hi All,

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?