3 Replies Latest reply on Aug 18, 2021 9:13 AM by pgeorge1

    Post Upgrade Powercenter Performance

    winsera New Member

      Hi,

       

      We have migrated from PC 9.5.1 on Solaris/Oracle to PC 10.4 on Windows/SQL Server and performance is less that impressive. Looking at the logs of a session would the following show the bottleneck is Informatica on Windows? The writer is waiting far longer on Windows I believe but am I reading that correctly?
      Solaris 9.5.1

      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]

       

      Windows

      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]

       

      We have raised a call with Informatica Support but had little useful information back.

      Anyone with any Solaris to Windows migrations that were not performant?

      Thanks in advance




       

        • 1. Re: Post Upgrade Powercenter Performance
          Syed Aziz Guru

          Hello Winsera,

           

          To start, you can take few stack traces from the session that are running slow.

           

          So if you see calls where write send the data packet to DB and read is where we wait from for an acknowledgement.

           

          For example, read calls (avg 0.013 seconds) take much longer than write calls (0.0001 seconds).  Usually anything under 0.0001 seconds is good anything over it will show performance issues.

           

          You would need to check with your DBAs and network team on this, you can share the analysis with them.

           

          Best regards,

          Syed

          • 2. Re: Post Upgrade Powercenter Performance
            JanLeendert Wijkhuijs Guru

            Hi,

             

            You switched from Solaris to Windows and from Oracle to SQL-server (repositories I presume).

            I think you also changed the underlying hardware as well but PowerCenter is seen as the bottleneck.

            The big issue with performance is it's a complex thing.
            I have seen well performing and ill performing PowerCenter on windows for various reasons.
            You need to take a look at the whole infrastructure if you really want to find out where your bottleneck is.
            Especially since you didn't do an in-place upgrade of Informatica.

             

            To give you an example of my experience with ill performing PowerCenter on Windows.

            I have been working in an environment where PowerCenter itself was blamed but eventually it turned out the storage was the issue since the IT department had configured back-ups to be stored in tier-1 and all the rest in tier-2 and tier-3 (tier-1 is the fastest) so caching etc was way to slow in PowerCenter so reader and writer were idle for large percentages.

             

            Regards,

            Jan Leendert

            1 of 1 people found this helpful
            • 3. Re: Post Upgrade Powercenter Performance
              pgeorge1 Guru

              The session stats you have posted may not be all that helpful.

              If I simply glance at the time difference between Windows and Solaris (Windows- 2k seconds vs. Solaris - 4600+ seconds) I would say that Windows is performing MUCH BETTER!

               

              But of course I think the row count must be different here if you say that Windows is performing worse than Solaris.

              Please upload the stats for a session run with a similar number of rows and also the stack traces Syed mentioned.

              At this point all that can be surmised from the stats in the session log is that the reader and DTM threads are taking more time and the writer is taking less.

              To further isolate the stacks are really needed here.