We're frequently getting the below error and due to this we suspect that since it is unable to log the information, VS is becoming unresponsive, even though it displays as up and running in the portal. Please find the below details and help me to resolve the issue.
DevTest Version : 10.3
Devtest components and DB are running in same server
Server: Windows server 2012 R2
2019-04-18 14:29:07,625Z (16:29) [Metrics persister processing 33 objects] WARN com.itko.lisa.utils.db.LisaSessionCustomizer - SQL query took a long time (1866 ms) : SELECT TXN_COUNTS_ID, VSE_NAME, VS_NAME, COUNTS_DATE, MISSES, REQUEST, SPECIFIC_HITS, TOTAL_COUNT, NODE_HITS FROM VSE_METRICS_TXN_COUNTS WHERE ((((VSE_NAME = ?) AND (VS_NAME = ?)) AND (REQUEST IS NULL)) AND (COUNTS_DATE = ?))
Please find attached the portal, registry and VSE logs for reference.