Same Query, Different Server, Different Plan

Question

Same Query, Different Server, Different Plan

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

sharadov SSC Enthusiast Points: 163 More actions · Answer 1

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 · Answer 2

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