TheSQLGuru (7/15/2016)
SQLBuzz (7/15/2016)
Strange ...I was just looking into the setting and i had found theseLogicalCPUs on Prod is 32
LogicalCPUs on Dev is 40
MAX DOP Setting on Prod is 8
MAX DOP setting on Dev is 16
And yet you had just told me the settings were identical on both boxes. :blink:
Also note that simply having a more powerful machine is cause for query plan differences even with every, and I mean EVERY OTHER SINGLE THING identical between the boxes/sql server/databases/etc.
And now we know the reason I don't answer these types of questions. 😛 The answer is always "something is different... go figure it out". 😉
--Jeff Moden
Change is inevitable... Change for the better is not.