Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan RE: Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

  • September 25, 2013 at 3:15 pm

    #1653359

    May be you can try updating stats on all the 8 base tables. Also check fragmentation on all the 8 tables. Verify the MAXDOP settings on both the machines.