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

  • December 20, 2012 at 2:55 am

    #1570466

    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 have checked the no of processor. QA server, where the parallelism is being used have th 2 processor. and staging server have the 4 processor, where the parallelism qry is not being used.