USM seems loading very slow after some time, even reports are being processed very slow
USM Slow due high number of alarms history at the USM
Check with this queries if you have a large number of alarms like above 80.000 into the DB on any of this Tables:
select count(*) from nas_alarms;
select count(*) from nas_transaction_log;
select count(*) from nas_transaction_summary;
CREATE INDEX IDX_NAS_TRANS_SUM04 ON NAS_TRANSACTION_SUMMARY (CLOSED);
Restart Trellis Probe
If just this procedure not help in the USM performance, please take a look at all this procedures to improve the DB performance for reference:
o Check the row count for maintenance_* tables and see if it has > 500 records.
This may contribute to performance problems. These tables may need to be truncated.
select count(*) from MAINTENANCE_SCHEDULE select count(*) from MAINTENANCE_SCHEDULE_MEMBERS select count(*) from MAINTENANCE_WINDOW
Best Practice regarding the SLM database:
Search for Bad/Special characters:
UMP Debug steps: