Performance problem / High memory usage Due To Applications suggestion - ITOM AutodiscoIssue There was a memory usage alert and a default semaphore alert on the same node.The performance of the instance was slow for some users. ReleaseParis Patch1 HotFix 5 CauseThis is known PRB1443969 fixed in Paris patch 4 and Quebec. The "Applications suggestion - ITOM Autodisco" job consumed a lot of memory in node where it was running(which caused a memory alert and a default semaphore exhaustion alert ) This jobs run every 1 hour "Applications suggestion - ITOM Autodisco" and it calls this script include: name = ProcessGroupServicehttps://<INSTANCENAME>.service-now.com/sys_script_include.do?sys_id=bf7dc8d873aa40105ad2db37aef6a78e The log file showed: 2020-11-06 06:34:58 (484) worker.4 worker.4 txid=ded683b11b50 [0:00:00.009] Compacting large row block (file.write: cmdb_running_process 10000 rows 160000 saveSize)2020-11-06 06:34:58 (502) worker.4 worker.4 txid=ded683b11b50 WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 1366762Query that got us here is: TABLENAME = cmdb_running_process ENCODED_QUERY = sys_created_on>2020-06-18 03:31:29 2020-11-06 06:45:17 (047) worker.4 worker.4 txid=ded683b11b50 *** Script: ProcessGroupService: processing members in page. number of members=14950702020-11-06 06:48:20 (766) worker.4 worker.4 txid=ded683b11b50 *** Script: ProcessGroupService: members_count from json=14950702020-11-06 06:48:20 (774) worker.4 worker.4 txid=ded683b11b50 *** Script: get process name from the first member record. process_name=wmiprvse2020-11-06 06:48:20 (780) worker.4 worker.4 txid=ded683b11b50 *** Script: [DEBUG] ProcessGroupService.createGroup:creating Group to Proc Mapping for cluster sys_id=090bec421b00641010220e5eea4bcbed2020-11-06 06:48:25 (846) worker.4 worker.4 txid=ded683b11b50 WARNING *** WARNING *** Transaction cancelled: Available memory is almost depleted The memory issue is caused by this specific feature : Calibrate fingerprint-based discovery ResolutionFIX PRB1443969 is fixed in "Quebec" and "Paris Patch 4". To get the fix you can Upgrade to Paris Patch 4 or Quebec WORKAROUND A) If customer is interested in Calibrate fingerprint-based discovery feature, you can use this workaround: 1. Download the work-around script attached to this KB and deploy it on the instance2. Once you import the attached xml, please change the scheduling job "Applications suggestion - ITOM Autodiscovery" under sysauto_script to active and set it to run every 3 hours instead of 1.Name = Applications suggestion - ITOM Autodiscoveryhttps://<INSTANCENAME>.service-now.com/sysauto_script.do?sys_id=311fb836730333005ad2db37aef6a7c0 Else, B) If customer is not interested in Calibrate fingerprint-based discovery feature, you can use this workaround: 1. You can disable the this feature : fingerprint-based discoveryIn order to disable only this feature, please see the section " Disable fingerprint-based discovery " which is at the very end of this documentation URL:https://docs.servicenow.com/bundle/paris-it-operations-management/page/product/discovery/task/calibrate-process-based-discovery.html Role required: discovery_admin Add this new system property: sys_property process.clustering.appfingerprint.enable = false Please change the scheduling job "Applications suggestion - ITOM Autodiscovery" under sysauto_script to inactiveName = Applications suggestion - ITOM Autodiscoveryhttps://<INSTANCENAME>.service-now.com/sysauto_script.do?sys_id=311fb836730333005ad2db37aef6a7c0