• And which plan is it that you want to use?

    Which plan is performing better?

    Did you clear the cache before running your tests on both servers?

    Both servers have same number of cpus, same affinity, same resource governor settings, same memory?

    Both servers have advanced power management turned off in bios?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events