on 12-15-2008 10:04 AM
Hi All,
In our XI system, the transaction SXI_MONITOR is very slow. i tried with some other threads, but not getting proper answer. Ours is PI7.o and SP level is SP16. The total no of messages is less than 2000.
Please help me.
Regards
Pradeep P N.
hi,
this is a guite common issue and it can be caused by many issues:
tables stats are not working properly
tables may need to be reogranized
messages may need to be archived
in most cases relatively simple basis check helps with such issues
Regards,
Michal Krawczyk
http://mypigenie.com - XI/PI FAQ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All
Thanks . My problem solved. it is with problem with DB Statistics.
Regards
Pradeep P N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pradeep,
This can be a trick to Reorganize the table, Activate the Switch deletion procedure in tcode SXMB_ADMIN and then Run the report RSXMB_TABLE_SWITCH.It wont take much time in your case(total messages 2000) Once this is done Moni will be faster.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Pradeep,
if you have only 2000msgs only, it must be either development system or fresh installation.
Are other transaction slow too ? If so, I would try to ask basis administrator to check the database consistency and to perform reorg action.
Rgds
Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.