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
george sibbald
SSC Guru
Points: 104210
More actions
April 15, 2013 at 2:16 pm
#1606615
excessive parallelism?
compare the query plans on the UAT and prod servers and go from there.
---------------------------------------------------------------------