2 Replies Latest reply on Aug 31, 2021 3:56 PM by Anukrati Tiwari

    Post Powercenter Upgrade Performance Issues

    winsera New Member

      Hi,

      We have upgraded from PC 9.5.1 on Solaris/Oracle to PC 10.4 on Windows/SQL Server. Performance is less than impressive and I need some help understanding the sessions logs.

      On Solaris we see stats from a session with the writer busy almost all the time.....

       

      Thread [READER_1_1_1] created for [the read stage] of partition point [sq_sel_CMS_ACT_NAR] has completed.

             Total Run Time = [4682.063928] secs

             Total Idle Time = [3063.917866] secs

             Busy Percentage = [34.560529]

      Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [sq_sel_CMS_ACT_NAR] has completed.

             Total Run Time = [4682.046069] secs

             Total Idle Time = [3947.073198] secs

             Busy Percentage = [15.697686]

             Thread work time breakdown:

                    exp_Add_Run_ID_to_CMS_ACT_NAR: 100.000000 percent

      Thread [WRITER_1_*_1] created for [the write stage] of partition point [CMS_CMS_ACT_NAR] has completed.

             Total Run Time = [4681.531454] secs

             Total Idle Time = [3.701643] secs

             Busy Percentage = [99.920931]

       

      Where as on Windows we see the writer far more idle.....

       

      Thread [READER_1_1_1] created for [the read stage] of partition point [sq_sel_CMS_ACT_NAR] has completed.

             Total Run Time = [2038.973028] secs

             Total Idle Time = [812.069040] secs

             Busy Percentage = [60.172644]

      Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [sq_sel_CMS_ACT_NAR] has completed.

             Total Run Time = [2038.941778] secs

             Total Idle Time = [980.543936] secs

             Busy Percentage = [51.909174]

             Thread work time breakdown:

                    exp_Add_Run_ID_to_CMS_ACT_NAR: 100.000000 percent

      Thread [WRITER_1_*_1] created for [the write stage] of partition point [CMS_CMS_ACT_NAR] has completed.

             Total Run Time = [2038.676144] secs

             Total Idle Time = [683.917927] secs

             Busy Percentage = [66.452841]

       

      Where would this indicate the session is waiting? We are not CPU maxing out on the server although they are a slower Ghz than the Solaris server.

      Any insight gratefully reeceived. We have raised a ticket with Informatica Support but they haven't found anything of any use.

      Cheers