Hi people !

I am facing a curious problem. I have this Job and one of its transformation is a tr that i input a database and perform some lookup steps to take values, and them i set some variables and to finish i write in an output step.

The curiosity about it is that this transformation runs without problems in other 2 envs but in my is taking more than 24 hours !
I just check mem configs, db configs, but when i analyze those DB activies i see a lot IDLE selects and i dont know what can be.

I thougth that maybe someone could just had this problem or some tip to give me.