SXI_MONITOR performance

[Former Member]

Hi guys,

The SXI_MONITOR (XML monitor) is performing very bad (timing out).

The answer could be found in the below report from SXMB_MONI_DB.

Question: how can I expand the "Maximum Number of Table Entries"?

Number of Table Entries 569.8

Maximum Number of Table Entries 200.0

Current Fill Level in % 285

Number of Logically Deleted Table Entries 0

Decline of Fill Level in % Following Deletion 285

Thanks

[rajasekhar_reddy14 · Accepted solution]

I think DB size reached max, try delete the old messages,better to do archive and deletion.

search in sdn for the same.

Regards.

Raj

[Former Member]

you have to delete old messages with a archive/deletion procedure

[Former Member]

Thanks! I have already set up deletion jobs, deleting everything that is more than 9 days old.

But the refered table size is very low - 200.000 is far from enough, and in other clients systems this value is much higher.

Please advise

[Eoin_Kierans]

With regard to the value 'maximum number of table entries this is only

a theoretical value. This value was calculated by DDic. Depending on

table size category, DB Hardware,etc.

You can see this value by the table size category. ( Transaction SE11

(table e.g. SXMSPMAST) -> Technical Settings -> Sizecategory )

The description is:

The size category determines the probable space requirement for a table

in the database.

You can select the categories 0 to 4 for your table. Each category is

assigned a specific fixed storage area value in the database. When you

create a table, initial space is saved for it in the database. If more

space is required later as a result of data that has been entered, the

storage space is increased in accordance with the category selected.

Press F4 on the field Size category to see the number of data records

that can be maintained for the individual categories of your table

without complications ensuing. These complications could be for example

a reorganization becoming necessary because the maximum space to be

reserved for the table was exceeded due

to the maintained size category."

[Eoin_Kierans]

You can check the following note #1362116 ' XI3.0, PI7.00-7.20: Performance of SXMB_MONI'.

With regard to the maximum number of table entries increasing this value would not have a bearing on the performance of the transaction. However if you wish to decrease the number of messages being held within the PI tables, ensure you have the necessary archiving and deletion jobs running as per note #872388 'Troubleshooting Archiving and Deletion in PI'

Regards

Eoin

[former_member193393]

Hello,

Go thru this thread: Seemed to be a similar issue.

Br,

SaiGanesh