Performance issues for Application Dependency Mapping (ADM) occur when the system discovers a server with a large number of identifiable processes and active connections whose relationships must be reconciled in the CMDB. The resulting SQL query can be very slow.
Steps to Reproduce
- Enable ADM.
- Discover a server with a large number of processes and connections that Discovery can identify.
Notice how long the query takes to run when the system attempts to reconcile all the relationships in the CMDB.
Note that processes that cannot be identified and associated with active connections do not require database reconciliation and do not create performance issues.
There are three possible workarounds:
- Use cvs checkin from fix
- Clear the check box in the glide.discovery.application_mapping property to disable the ADM feature
- Upgrade to a version listed in the Fixed In field below
Related Problem: PRB630274