Skip to Content
avatar image
Former Member

How to Improve Performace of SXI_MONITOR?

How to Improve Performace of SXI_MONITOR?

Dear Experts!,

I have faced  Performace's Issues on SXI_MONITOR @ PI

When I try to open a XML Message, it's exagerated slow. I can open the messages, but It takes forever.

I'd like to know if someone knows how to improve and optimize the Performace.

Is there any cacher or parameter I could change?

Best Regards,

Denner da Silva Florentino Andrade

Denner da Silva Florentino Andrade

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 19, 2016 at 02:30 PM
    13

    Check the below discussion

    SXI_MONITOR is slow | SCN

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Bhavesh Kantilal

      You were right.

      I set the right parameters on SXMB_ADMIN

      than the jobs could delete and archive the XML PI messages.

      thank you Bhavesh!


      Best regards.


      Denner

  • Jul 26, 2016 at 12:57 PM

    Seems like you describe a message size issue.

    As far as I know there is no solution for that.

    It is possible that you are sending very large files beyond the PI capabilities.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2016 at 10:06 AM

    1. Goto transaction SAT.

    2. Then insert transaction sxi_monitor and Execute.

    3. Open a message and go back.

    4. Now you can see a Runtime Analysis. There you can see on which step you have performance problems. Please post a screenshot.

    You also can see there some tables. Take the name from the tables with the biggest running time.

    Go to transaction DB20 insert the table name and klick on Refresh (Ctrl + F1). With create statistics (Ctrl + F2) you can create new statistics.

    regards,

    Benedikt

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 20, 2016 at 08:24 AM

    Hello Denner,

    If you have applied the statistics (If you're DB is Oracle use the note #1020260) and the archive and deletion jobs are also running you may wish to check if you have a large number of messages in a non final message or adapter status.

    Any messages in non final status will not be removed by these jobs. To check this you can run the reports RSXMB_SHOW_REORG_STATUS and RSXMB_SHOW_STATUS.

    You may also refer to the KBA #2191585 - The Final Message and Adapter Statuses of PI Messages.

    Regards

    Eoin

    Add comment
    10|10000 characters needed characters exceeded