probe_discovery queue is filling up

book

Article ID: 7040

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

The probe_discovery queue is filling up

Cause

Low Java Memory setting for the discovery_server probe and table indexes needs to be rebuild regularly

Environment

Any Discovery_Server/Agent probe versions

Resolution

1 - To allocate more (e.g. double) Java Memory for the discovery server probe open the raw configuration with Shift - right mouse click on the probe in IM.

select startup - opt

updating the following:


java_mem_max = -Xmx1024m

The above is the default what ever your value please double then deactivate and activate the probe to have it take affect.

2 - Setting up a sql Job to run the following queries on a nightly basis:

ALTER INDEX ALL ON CM_COMPUTER_SYSTEM REBUILD; ALTER INDEX ALL ON CM_DEVICE REBUILD; ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ATTR REBUILD; ALTER INDEX ALL ON CM_DEVICE_ATTRIBUTE REBUILD; ALTER INDEX ALL ON CM_CONFIGURATION_ITEM REBUILD; ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC REBUILD; ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_DEFINITION REBUILD; ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC_DEFINITION REBUILD; ALTER INDEX ALL ON CM_NIMBUS_ROBOT REBUILD; ALTER INDEX ALL ON CM_DEVICE REBUILD; ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ORIGIN REBUILD; ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_ATTRIBUTE REBUILD; ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CI REBUILD; ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CS REBUILD; ALTER INDEX ALL ON CM_RELATIONSHIP_CS_CI REBUILD; ALTER INDEX ALL ON CM_DISCOVERY_NETWORK REBUILD; ALTER INDEX ALL ON S_QOS_DATA REBUILD; ALTER INDEX ALL ON NAS_TRANSACTION_SUMMARY REBUILD; ALTER INDEX ALL ON NAS_ALARMS REBUILD; ALTER INDEX ALL ON NAS_TRANSACTION_LOG REBUILD;

3 - Udm_manager.cfg:

 - In the " Raw Configure" setup, add the following key under the " Setup" section: " schema_transact_retries" and set the value to 5000.

 - Also change the "schema_connection_timeout_minutes" value to 30