Same Query, Different Server, Different Plan

• sharadov

  SSC Enthusiast

  Points: 163

  More actions

  October 6, 2014 at 5:56 pm

  #1750453

  We bumped down the memory to 128 Gb on the SQL2, and we see the same plan as SQL1. Kind of throws all logic out of the window. But Paul White's article explains it.

  http://dba.stackexchange.com/questions/53726/difference-in-execution-plans-on-uat-and-prod-server/55254#55254

  Thanks everyone for sharing your insights!

• jvkondapalli

  SSCommitted

  Points: 1587

  More actions

  October 6, 2014 at 5:57 pm

  #1750454

  we are able to match up the execution plan by throttling the max memory setting in Server 1.

  Here's the KB http://support.microsoft.com/kb/2413549 that explains more memory could sometimes cause inefficient plans! Thank you Microsoft!

  Thanks to Paul White for pointing this out in a different thread for a different issue.

  Thank you everyone for taking time and looking into this.

  However, still curious of what "occasionally" means in the KB article's CAUSE section!

  Thanks
  Jagan K