poor performance doing ODBC from an iSeries

  •  

    Hi all,

    we have an development-server, an integration-test-server and a production server. the integration-test-server is new. we do ETL via ODBC from an iSeries (AS400). the transfer time for a large file (20Mio records) is quite good on the old servers, but it is poor on the new server. we can't see any differences neither in the W2K3-setup nor in the SQLS2000-setup of our 3rd server.  

    regards

    ralf 

  • What hardware difference is there between the  integration-test and production/development server?

     

  • there are no differences. all servers have 8GB memory and the same cpu-power. Is it possible that the new one does not use all of its 8GB? If so, are there any parameters outside SQL-server software (on the operating system) that are not correctly adjusted? Ralf 

  • Are the execution plans the same on all server?

    You can see how much memory uses with performance monitor & sql counters.

    The new server, does it has the same RAID/SAN implementation?

    Linked server/collation have the same options?

    ODBC driver same version?

  • I am going to check this.

    Thanks

    Ralf

Viewing 5 posts - 1 through 4 (of 4 total)

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