• Whilst reducing the number of Processors used will reduce parallelism waits it may not be the best way to 'fix' the query ie. there are probably other underlying issues

    A good link on the 'barking dog analogy'

    http://www.sqlsoldier.com/wp/sqlserver/thebarkingdoganalogy