Post reply

Performance Comparison

  • February 7, 2009 at 11:09 pm

    #127444

    Hi All,

    I have two identical servers (TST & PRD) installed on two seprate machines. Both have identical databases, procedures and DTS running. But PRD is way too slow compared to TST. Some DTS packages are taking over 24 hrs to complete while the same takes only 30-40 mins on TST.

    How can I figure out the problem.

    Please help with detailed steps to a newbie.

  • February 8, 2009 at 8:54 am

    #940157

    Is the load the same on the two servers (number of concurrent users, concurrent queries)? Is the data size the same on the two servers?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 8, 2009 at 10:58 am

    #940171

    the load is almost the same. The data on PRD is not more than 5-10% of TST. Infact a few days ago everything was okay.

    What comparison tests can be performed (step by step please).

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

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