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:36 pm

    #1653368

    ssismaddy (9/25/2013)

    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.

    Checked the fragmentation on all 8 tables. Nothing bad (worst table is 35%). MAXDOP is set to 4 on both machines.

    Update stats may take a while and I'm hesitant unless we are off-hours.

    Thanks.

    John.