Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Use of Parallelism. RE: Use of Parallelism.

  • December 20, 2012 at 2:50 am

    #1570465

    SQLRNNR (12/20/2012)

    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?

    I want to use the execution plan which have the parallelism. It is working faster.

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