Post reply

Two Server have different times on processing ETL.

  • June 18, 2010 at 1:28 pm

    #223002

    Here is my environment, I have one production server and one development server. The development server is a copy of the production and has the exact same ETL jobs. These are part of a data warehouse. I have auditing on the SSIS packages to log the execution times. Almost every package takes 20-30% longer to execute on the production server vs the development.

    The hardware on these is pretty close, the development server doesn't quite have as good of a processor so i would assume it would be slower.

    Is there any suggestions on how to go about figuring why these is such a big difference on SSIS packages processing.

  • June 18, 2010 at 2:19 pm

    #1182345

    well, the existing load on the production server would certainly affect the speed, as it has to share/complete for resources with regular users;

    the devleopment server probably has a near-no load on it, as it's for development.

    separate from that, statistics on either server could affect the ETL if they are not up to date; you could consider updating stats prior to running the ETL on production and see if there is a difference as well.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 18, 2010 at 2:23 pm

    #1182347

    Thanks for the reply, Ill try updating stats.

    The ETL process occurs at 2:00 am when there should be no one on it the servers. I havent confirmed that though.

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

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