Highlighted
Super Contributor.
Super Contributor.
265 views

(UCMDB) Support Tip –uCMDB UI slow because of db slowness

Topic


Customer can see slowneess on UCMDB UI

Line 1590: 2017-09-25 02:31:13,118 INFO [Process Results Thread-MM_InventoryDiscoverybyScanner] - 109559ms 639706208 650884126 92165709 BATCH(11) UPDATE CDM_INSTALLED_SOFTWARE_1 SET A_USAGE_HOURS_LAST_QUARTER = ?, A_USAGE_HOURS_LAST_MONTH = ?, A_USAGE_DAYS_LAST_YEAR = ?, A_INFOCUS_USAGE_PERCENT = ?, A_INFOCUS_USAGE_D_856339942 = ?, A_INFOCUS_USAGE_H_1966644303 = ?, A_INFOCUS_USAGE_D_765962743 = ?, A_INFOCUS_USAGE_LAST_USED = ?, A_USAGE_LAST_USED = ?, A_USAGE_DAYS_LAST_MONTH = ?, A_USAGE_DAYS_LAST_QUARTER = ?, A_INFOCUS_USAGE_D_1065560163 = ?, A_USAGE_HOURS_LAST_YEAR = ?, A_UTILIZATION_UPDATE_DATE = ?, A_INFOCUS_USAGE_H_1726355598 = ?, A_USAGE_PERCENT = ?, A_INFOCUS_USAGE_H_425663301 = ?, A_DATA_UPDATED_BY = ? WHERE CMDB_ID = ?
Line 1618: 2017-09-25 02:33:52,659 INFO [Process Results Thread-MM_InventoryDiscoverybyScanner] - 109137ms 1188794967 987652932 488930670 BATCH(1) UPDATE CDM_INSTALLED_SOFTWARE_1 SET A_USAGE_HOURS_LAST_MONTH = ?, A_INFOCUS_USAGE_H_1966644303 = ?, A_UTILIZATION_UPDATE_DATE = ?, A_INFOCUS_USAGE_D_765962743 = ?, A_USAGE_DAYS_LAST_MONTH = ?, A_DATA_UPDATED_BY = ? WHERE CMDB_ID = ?
Line 1735: 2017-09-25 02:43:21,045 INFO [Process Results Thread-MM_InventoryDiscoverybyScanner] - 100417ms 1474735960 1211543212 2099653373 BATCH(6) UPDATE CDM_INSTALLED_SOFTWARE_1 SET A_USAGE_HOURS_LAST_QUARTER = ?, A_USAGE_HOURS_LAST_MONTH = ?, A_USAGE_DAYS_LAST_YEAR = ?, A_INFOCUS_USAGE_PERCENT = ?, A_INFOCUS_USAGE_D_856339942 = ?, A_USAGE_HOURS_LAST_YEAR = ?, A_UTILIZATION_UPDATE_DATE = ?, A_INFOCUS_USAGE_H_1726355598 = ?, A_INFOCUS_USAGE_LAST_USED = ?, A_USAGE_PERCENT = ?, A_USAGE_LAST_USED = ?, A_DATA_UPDATED_BY = ? WHERE CMDB_ID = ?
Line 1776: 2017-09-25 02:46:16,342 INFO [Process Results Thread-MM_InventoryDiscoverybyScanner] - 111664ms 1590136353 74890602 441683876 BATCH(1) UPDATE CDM_INSTALLED_SOFTWARE_1 SET A_USAGE_HOURS_LAST_YEAR = ?, A_UTILIZATION_UPDATE_DATE = ?, A_INFOCUS_USAGE_LAST_USED = ?, A_USAGE_LAST_USED = ?, A_DATA_UPDATED_BY = ? WHERE CMDB_ID = ?
Line 1779: 2017-09-25 02:46:16,545 INFO [qtp1544120201-138330 - /mam-collectors/collectors?cmd=sendResultTouch&SessionCustomerId=1] - 107640ms 560516410 2072755918 UPDATE CDM_ROOT_1 SET A_ROOT_CANDIDATEFORDELETETIME = ?, A_ROOT_ACTUALDELETETIME = ?, A_ROOT_LASTACCESSTIME = ?, A_ROOT_ISCANDIDATEFORDELETION = ? WHERE EXISTS (SELECT 1 FROM #CDM_TMP_OBJID WHERE #CDM_TMP_OBJID.CMDB_ID = CDM_ROOT_1.CMDB_ID AND #CDM_TMP_OBJID.T_VALUES_INDEX=0); Values: 1508049868890,1509777868890,1506321868890,false

 

Response

setting appilog.agent.probe.sendtouchResultsToServer.maxObjects = 100 resolve the issue

Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.