Transaction SXI_MONITOR problem

[Former Member]

Hello,

I have performance problem with SXI_monitor transaction at R/3 side.

when i am trying to open the SXI_Monitor, system taking more time than normal.

Time to open an message 9 minuts ;and 6 seconds

Is there any network related problem in the system?

could you any one tell me why it is happend?

Regards,

satya..

[Former Member · Accepted solution]

Hi,

This is mostly due to the high fill level in database. The query takes more time!

1) SXMB_MONI -> Persistence Layer Analysis

2) DB02 - Show the DB fill level

An ideal solution is to setup Archive and Deletion jobs so that the database fill level stays in the lower side.

Regards,

Anish

[Former Member]

Hi Satya Pawan,

The issue might be with the network or with huge volumes of data.

Refer the below blog:

/people/daniel.graversen/blog/2008/11/03/performance-tuning-of-pi

Thanks,

Hanu

[Former Member]

Hi

Run the stats on the following tables and that will fix the issue.

SXMSPMAST

SXMSPEMAS

Make sure Archiving configured in the system.

[Former Member]

Hello Satya!

Please check the SAP note #1124574 - Performance improvement for 'SQL Server' in trans SXMB_MONI

Do you have Archive and Deletion jobs configured? They are required in order to reduce the number of messages in the persistence layer and, therefore, reduce the query time by the SXI_MONITOR transaction.

- Activate the statistics for the tables, using the DB20 transaction and also reorg them. The XI tables are http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

Regards,

Lucas

[Former Member]

This could happen due to overload on system or due to network issue but check with your BASIS team they can tell you the exact reason for this.