Home Forums SQL Server 2008 SQL Server 2008 Administration No performance gain on queries on different servers with considerable hardware change RE: No performance gain on queries on different servers with considerable hardware change

  • It looks like the standard edition only supports up to 4 processors so going to a 32 proc machine probably doesn't make a difference.

    MSDN

    Were there upgrades in the storage configuration? You should do some analysis to figure out where the bottleneck is in the query. If the bottleneck was in the disk, then upgrading the the server alone would not make a big impact on your query performance.