USM Slow due high number of alarms history at the USM

book

Article ID: 4483

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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

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;

Environment

UIM 8.3.1 or later versions

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://knowledge.broadcom.com/external/article?articleId=73421

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