Prep. Reset the Cost_Threshold_for_Parallelism to Microsoft’s default (5) if it has been changed
1. Set MaxPOD from the default (0) to Microsoft recommendations (IE: number of cores in 1 cpu max 8)
2. Run dbo.sp_BlitzCache, and from the first result table cut-n-paste the first three columns into a spreadsheet.
3. Sort the spreadsheet by column-2 ‘cost’ and try to find a natural boundary between OLTP and OLAP
queries.
4. Set Cost Threshold for Parallelism in the middle of this split.
NB: do not run #2 again as the results will be deceptive unless (prep) is actioned first
Database Consultant 