InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:56:38 GMT20http://www.sqlservercentral.com/Forums/Topic675195-360-1.aspxIf it's two different plans, that's probably the issue.Make sure the same parameters are in use on both and make sure that both have updated statistics and defragmented indexes.The very best way to compare apples to apples is to restore a backup from the first server on the second. That'll let you be sure that you have a precise copy of the data, the structures, statistics, indexes, etc. Then, any differences are likely to be caused by hardware; memory, cpu or disk.Fri, 13 Mar 2009 10:30:08 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic675195-360-1.aspxThe query plans are indeed different. The actual plan on TEST has a nested loop, an index scan and a key lookup. The actual plan on BISQL parallelism and a table scan. So the reason for the longer elapsed time with the shorter cpu time might be I/O? They both produce the same amount of recordsFri, 13 Mar 2009 10:06:24 GMTAndrew Hartnetthttp://www.sqlservercentral.com/Forums/Topic675195-360-1.aspxCPU time is not the only metric, don't forget I/O as well. Have you tried looking at the actual query plan (not the estimated one) for the query on each server? If so is there a difference?Fri, 13 Mar 2009 09:04:58 GMTHenry Treftzhttp://www.sqlservercentral.com/Forums/Topic675195-360-1.aspxThis is my first post on here so bare with me. I have a sql query that I have run on two different servers. I am trying to get some performance metrics so I can see which server has a better architecture. The only thing that I do not understand is that the TEST server has a smaller elapsed time but has a longer CPU seconds/Iteration Avg. It would seem to me that if the cpu time is longer that the elapsed time would follow the same trend. Any ideas as to why this is would be helpful. ThanksServer TEST BISQLClient Seconds/Iteration(Avg): 14.4086 17.6521CPU Seconds/Iteration (Avg): 62.8717 37.0128Actual Seconds/Iteration: 14.4101 17.6065Logical Reads/Iterations (Avg) 4507028 4507138Elapsed Time 00:24:01.224 00:29:26.779Fri, 13 Mar 2009 08:09:11 GMTAndrew Hartnett