9 Replies Latest reply on Dec 17, 2010 8:30 AM by Bill Robinson

    Slow ETL and slow BDSSA

    Jim Campbell

      ETL is running slower and slower to the point where it now only runs every other day as it is still running when the daily script kicks off on the next day.  We are on Blade 8.0sp6 and BDSSA 2.0sp3.  From Metadata navigator the scenario that takes most of the time is:

       

      5_INVENTORY_5

      SUPERVISOR

      07/12/2010 07:00:07

      08/12/2010 19:28:23

      0

      131296.0

       

      Within this scenario, the step that is the culprit looks to be:

       

      Procedure

      LOAD_OM_SNAPSHOT_5

      LOAD_OM_SNAPSHOT_5

      2010-12-07 07:11:23.127

      2010-12-08 19:28:23.42

      1

      0

       

       

      Is there any way to determine exactly whats causing this to run so slowly?  We haven't had any major changes to the number of servers or to our inventory snapshot job.  Would a gradual accumulation of snapshots cause the job to slow down?