Home Forums SQL Server 2014 Development - SQL Server 2014 Same query different Execution plan on two different server RE: Same query different Execution plan on two different server
SQL_Surfer
SSCrazy Eights
Points: 8318
More actions
July 17, 2017 at 12:07 pm
#1951246
Good catch. CPU and memory and I/O same. But tempdb config is slightly different. I've tempdb split inot 8 files on server 1 vs 1 file. Would that cause parallel plan on server 1?