Low performance in SXMB_MONI

[Former Member]

When accesing to the xml message versions of a single message in SXMB_MONI, it takes a very long time.

What could be the cause of this bad performance?

Thanks.

[marksmyth]

Hi Alberto

This can be caused by DB related issues. An update of the DB statistics usually resolves this.

If you use the Oracle DB, apply note #1020260 Delivering Oracle statistics.

Also, ensure you have configured Archiving and Deletion to ensure that XI messages are deleted from the DB tables. Too many entries in the DB tables can also cause this issue. See note #872388 Troubleshooting Archiving and Deletion in XI 3.0 / PI 7.0.

Regards

Mark