USM Slow due high number of alarms history at the USM

Document ID : KB000004483
Last Modified Date : 25/07/2018
Show Technical Document Details
Issue:

USM seems loading very slow after some time, even reports are being processed very slow

Environment:
UIM 8.3.1 or later versions
Cause:

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;

Resolution:

 
CREATE INDEX IDX_NAS_TRANS_SUM04 ON NAS_TRANSACTION_SUMMARY (CLOSED);


Restart Trellis Probe

Additional Information:

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:

https://comm.support.ca.com/kb/ump-usm-slow-performance-guide-and-troubleshooting-checklist/kb000041017
 

Indexing:

https://docops.ca.com/ca-unified-infrastructure-management-probes/en/alphabetical-probe-articles/data_engine/data_engine-versions-8-0-8-3/v8-0-data_engine-im-configuration

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

Fragmentation:
https://comm.support.ca.com/kb/usm-slow-due-high-number-of-alarms-history-at-the-usm/kb000004483

Best Practice regarding the SLM database:
https://comm.support.ca.com/kb/slm-database-best-practices-indexing-strategy-and-maintenance/kb000034247

Search for Bad/Special characters:
https://comm.support.ca.com/kb/how-to-search-for-badspecialnonprintable-characters-in-mysql/kb000057270

UMP Debug steps:
https://comm.support.ca.com/kb/How-can-I-enable-DEBUG-mode-for-UMP-USM-ListViewer-or-Performance-Report-displays/kb000033962