A DS Job taking very long time

[siba_pkd21]

Hi All

A DS Job taking 11-18 Hours to complete and it retrieves arounds 115550635 row count.

What are the areas needs to be checked to reduce the execution time.

BR

sIBA

[Julian_Riegel]

Hi Siba,

Where are you extracting from? How many columns does your source have? Are you doing a simple 1 to 1 extraction or are you applying logic as well?

Julian

[amontella96]

hi @siba_pkd21 nowadays nobody has time to describe their issue in details, rite?

Is this job started to go slow after days/months/years? did any changes happen in the same timeframe where the job become slow? 

without details i can throw a solution with crystal ball, you have a sql server AND you upgraded it without changing the datastore settings sql version as per 2768769  cheers!A

[siba_pkd21]

Hi Amontella,

There was a bods upgradation happened from version 4.2 to 4.3 six months ago.

Also I could not able to trace when this happened because while cheking for old jobs , I can't able to find old jobs beyond 30 days.

Regards

Siba