High CPU usage on UIM maintenance_mode probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The maintenance_mode probe uses high CPU and spikes at random time.

Environment

UIM: 20.4 Cu9
UIM DB: MS SQL Server

Resolution

Please deactivate the maintenance mode probe and rebuild below indexes (MS SQL Server)

ALTER INDEX ALL ON MAINTENANCE_SCHEDULE REBUILD WITH (ONLINE = ON);

ALTER INDEX ALL ON MAINTENANCE_WINDOW REBUILD WITH (ONLINE = ON);

ALTER INDEX ALL ON MAINTENANCE_SCHEDULE_MEMBERS REBUILD WITH (ONLINE = ON);

ALTER INDEX ALL ON CM_DEVICE REBUILD WITH (ONLINE = ON);

ALTER INDEX ALL ON CM_COMPUTER_SYSTEM REBUILD WITH (ONLINE = ON);

After rebuilding the indexes, please activate maintenance_mode probe .

recommend to schedule a job to rebuild the indexes at weekly intervals.