Viewing 3 posts - 1 through 3 (of 3 total)
Thank you for the suggestion on the Cost Threshold for Parallelism setting. I'm going to change the value and see how the system performs.
There's no doubt that the execution...
July 1, 2014 at 8:17 am
#1726211
Cost threshold for parallelism on both boxes. ANSI connection settings on both boxes. Get an estimated execution plan from both boxes and compare them.
Cost threshold for parallelism om both...
July 1, 2014 at 6:30 am
#1726147
Update to the questions:
Production Box - Running MSSQL 2008R2 - compatibility_level = 90
Development Box - Running MSSQL 2012 - compatibility_level = 90
July 1, 2014 at 6:14 am
#1726139