Post reply

hw comparasion

  • June 18, 2008 at 6:29 am

    #187301

    hi,

    i have tow different hw machines: A and B.

    A: 2CPU 2.4Ghz, 4GB RAM, Win2003R2 Standard, SQL 2005 SP2

    B: 4CPU 3.6GHz, 24GB RAM, Win2003 x64 Enterprise, SQL 2005 x64 SP2

    i have the same db on both machines but running the same query produced different results as time performace; B seems to be twice slower as A.

    it is normal ?

  • June 18, 2008 at 7:41 am

    #830420

    Lots of things go into coming up with the execution plan for a query in SQL Server. Take a look at the execution plans on each server. It is likely that the slower one has come up with a bad execution plan. This could be due to a poorly written query, outdated statistics, data differences, or a number of other variables.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply