About Company
Industry: Healthcare
Location: India
Challenge: Too much memory consumed by the Cache degrades overall server performance, which needs to be optimized for better server performance.
Product Used: NetDiagnostics
Result(s):
1)DB queries that are taking a higher execution time now can be tuned.
2)Faster identification and resolution of very slow transactions.
Challenge
The National Health Agency (NHA) under Ministry of Health and Family Welfare has launched pilot for Beneficiary Identification System (BIS), which is a process whereby the identification criteria (as per AB-NHPM guidelines) will be applied on SECC and RSBY database to confirm application from ‘entitles’ beneficiaries. Ayushman Bharat will target about 10.74 crore poor, deprived rural families and identified occupational category of urban workers’ families as per the latest Socio-Economic Caste Census (SECC) data Yet, as NHA introduced new online BIS services, for 10.74 crore people, The IT team found itself in need to monitor multiple systems to ensure the smooth running of the company’s operations. It was nearly impossible to follow Business Transactions end-to-end through a complex environment of Windows, Linux, MS SQL, MySQL, and Oracle technologies.
“We were unable to find out the RCA for the issues, suddenly the application gets crashed and we were not being alerted to problems “
Identify And Fix The Root Cause For Application Performance Degradation
BIS is the National Standard Body of India established under the BIS Act 2016 for the harmonious development of the activities of standardization, marking and quality certification of goods.
“A cohesive application performance monitoring (APM) strategy that focuses on customers’ digital experience, business transactions, application dependencies and infrastructure performance is key to achieving application performance success.”
Solution
❖ Provided Real-time alerts on any health degradation of application/server/ databases.
❖ Continuous monitoring of Analytics & RCA of frequent issues which helps to increase the performance.
❖ More than 80% of threads went into waiting state also One query taking 19 sec of execution time which is tuned.
❖ The NetDiagnostic tool is helped to analyze why the heap consumptions is so high indicative of memory leaks in application by taking the heap dumps manually or automated.
❖ Implementation of optimized GC algorithms helped to manage the frequency of GCs, and also waiting threads are being optimized for better performance.
Benefits
NetDiagnostics implementation resulted in major optimization(s) across NHA’s BIS application, not only in terms of the product’s ability to detect issues but also in increasing the application performance. Some of the benefits derived after deploying NetDiagnostics were as follows:
❖ DB queries were optimized, which are taking more than 3 secs to execute.
❖ Heap memory consumption is decreased and controlled the memory leaks.
❖ Proactive suggestions related to architectural and deployment improvements, like connection pooling mechanism problems, helped to solve the complex problems.
❖ Ability to compare the health of the application for improvements – before / after.