OC are loading slow or never loads
search cancel

OC are loading slow or never loads

book

Article ID: 246421

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Operator console never loads(alarms, inventory etc) or alarms loads slowly.

Environment

Release : 20.32

Component : UIM OPERATOR CONSOLE - ALARM VIEWER

hub 9.31,

nas 9.32Hf1,

ems 10.24, 

Resolution

After enabling the daily reindexing the OC loads alarms, inventory, groups successfully. 

These are the key tables with indexes that require defragmentation (DAILY). Ask your DBA to set up a job to run this DAILY (off-hours) index defrag job.

ALTER INDEX ALL ON CM_CONFIGURATION_ITEM REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_ATTRIBUTE REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_COMPUTER_SYSTEM REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CI REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CS REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_RELATIONSHIP_CS_CI REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_RELATIONSHIP_CS_CS REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ATTR REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_BLACKLIST_COMPUTER_SYSTEM REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_DEVICE REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_DEVICE_ATTRIBUTE REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_DISCOVERY_NETWORK REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_DEFINITION REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC_DEFINITION REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_NIMBUS_ROBOT REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ORIGIN REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON S_QOS_DATA REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON NAS_TRANSACTION_SUMMARY REBUILD WITH (ONLINE = ON);
ALTER INDEX ALL ON NAS_ALARMS REBUILD WITH (ONLINE = ON);