Monitoring and Root Cause Analysis for Database Performance Issues
DOI:
https://doi.org/10.63282/3050-9262.IJAIDSML-V6I3P125Keywords:
Database Monitoring, Performance Analysis, Root Cause Detection, Query Optimization, Observability, AutomationAbstract
Database systems must manage a number of different workloads, distributed architectures as well as intense performance demands in the modern digital era. Companies are using data in increasing amounts to make these kinds of decisions, so even little drops in the efficiency of databases can be terrible for business. This study stresses the necessity of careful monitoring when sophisticated root cause analysis to make certain the databases work properly & are more reliable. Most standard tracking devices just give warnings after an incident has gone wrong and don't give comprehensive diagnosis information. This makes it tougher to resolve things and takes extra time to do so. The proposed method solves these kinds of problems by using continuous performance monitoring, anomaly detection along with correlation analysis to find performance regressions and bottlenecks in actual time. The system sets an ever-changing performance foundation by looking at things like query latency, resource use, and payment throughput. This makes it easier to find those issues early and figure out what's contributing to them on your own. The method uses algorithmic learning for predictive evaluation, which means it can generate predictions about trends along with improvements before they happen. The results of the analysis show that the system is now considerably more stable, it takes a shorter time to fix problems, and it has become simpler to find bugs than it was via conventional reactive monitoring. The results show just how crucial it is to employ observability, automation, and analytics in combination to make database management of performance a proactive and smart practice compared to a reactive one. This study strengthens the field of data structure optimization by presenting a scalable, analytics-driven scheme that empowers administrators to guarantee consistent performance, reduce downtime, and further improve customer satisfaction in dynamic database-based systems.
References
[1] Jayathilaka, Hiranya, Chandra Krintz, and Rich Wolski. "Performance monitoring and root cause analysis for cloud-hosted web applications." Proceedings of the 26th International Conference on World Wide Web. 2017.
[2] Magalhães, João Paulo, and Luis Moura Silva. "Root-cause analysis of performance anomalies in web-based applications." Proceedings of the 2011 ACM Symposium on Applied Computing. 2011.
[3] Latino, Mark A., Robert J. Latino, and Kenneth C. Latino. Root cause analysis: improving performance for bottom-line results. CRC press, 2019.4. Suryadevara, Siva Sai Krishna, and Santosh Nakirikanti. “Blockchain-Backed Content Authenticity Verification Framework”. International Journal of Artificial Intelligence, Data Science, and Machine Learning, vol. 5, no. 1, Mar. 2024, pp. 242-5.
[4] Banerjee, Dipyaman, Venkateswara Madduri, and Mudhakar Srivatsa. "A framework for distributed monitoring and root cause analysis for large ip networks." 2009 28th IEEE International Symposium on Reliable Distributed Systems. IEEE, 2009.
[5] Parakala, Adityamallikarjunkumar. "Emergence of AI Trust Layers & Governance." International Journal of Artificial Intelligence, Data Science, and Machine Learning 6.2 (2025): 144-152.
[6] Katangoori, Sivadeep. “Streaming Feature Stores and Real-Time ML Inference on Cloud-Native Infrastructure”. Newark Journal of Human-Centric AI and Robotics Interaction, vol. 5, Jan. 2025, pp. 282-08.
[7] Soldani, Jacopo, and Antonio Brogi. "Anomaly detection and failure root cause analysis in (micro) service-based cloud applications: A survey." ACM Computing Surveys (CSUR) 55.3 (2022): 1-39.
[8] De Carvalho, Tiago Filipe Rodrigues. Root Cause Analysis in Large and Complex Networks. Universidade de Lisboa (Portugal), 2008.
[9] Schroeder, Bianca, and Garth A. Gibson. "A large-scale study of failures in high-performance computing systems." IEEE transactions on Dependable and Secure Computing 7.4 (2009): 337-350.
[10] Muppaneni, Kavya. “Progressive Web Apps: Offline UX Benchmarking”. International Journal of Emerging Trends in Computer Science and Information Technology, vol. 5, no. 2, June 2024, pp. 174-83.
[11] Chen, Mike Y., et al. "Pinpoint: Problem determination in large, dynamic internet services." Proceedings International Conference on Dependable Systems and Networks. IEEE, 2002.
[12] Eckerson, Wayne W. Performance dashboards: measuring, monitoring, and managing your business. John Wiley & Sons, 2010.
[13] Muppaneni, Rajarshi Krishna. “Low-Code Revolution: How Power Platform Extends Dynamics 365 Capabilities”. International Journal of Artificial Intelligence, Data Science, and Machine Learning, vol. 4, no. 3, Sept. 2023, pp. 162-71.
[14] Massie, Matthew L., Brent N. Chun, and David E. Culler. "The ganglia distributed monitoring system: design, implementation, and experience." Parallel Computing 30.7 (2004): 817-840.
[15] Szewczyk, Robert, et al. "An analysis of a large scale habitat monitoring application." Proceedings of the 2nd international conference on Embedded networked sensor systems. 2004.
[16] Takkalapally, DevenderRao, and Mahender Rao Takkellapally. “AI-SynPerf: Synthetic Data Intelligence Framework for 5G Mobile Performance Simulation”. International Journal of Emerging Trends in Computer Science and Information Technology, vol. 5, no. 1, Mar. 2024, pp. 182-94.
[17] Gaddam, Rohit Reddy. “Cost-Aware Autoscaling for Batch Vs. Online Inference”. International Journal of Emerging Trends in Computer Science and Information Technology, vol. 3, no. 4, Dec. 2022, pp. 134-43.
[18] Parakala, Adityamallikarjunkumar. "Self‑Learning Bots & Cloud‑Native Platforms." International Journal of Emerging Trends in Computer Science and Information Technology 5.4 (2024): 132-141.
[19] Cherkasova, Ludmila, et al. "Anomaly? application change? or workload change? towards automated detection of application performance anomaly and change." 2008 IEEE International Conference on Dependable Systems and Networks With FTCS and DCC (DSN). IEEE, 2008.
[20] Kumar Doodala, Appala Nooka. “Continuous Compliance Testing in Healthcare IT Using Shift-Right QA Strategies”. International Journal of Artificial Intelligence, Data Science, and Machine Learning, vol. 6, no. 1, Mar. 2025, pp. 258-67.
[21] Bernardin, Keni, and Rainer Stiefelhagen. "Evaluating multiple object tracking performance: the clear mot metrics." EURASIP Journal on Image and Video Processing 2008.1 (2008): 246309.
[22] Su, Ya-Yunn, Mona Attariyan, and Jason Flinn. "Autobash: improving configuration management with operating system causality analysis." ACM SIGOPS Operating Systems Review 41.6 (2007): 237-250.
[23] Saeed, Mohammed, et al. "Multiparameter Intelligent Monitoring in Intensive Care II: a public-access intensive care unit database." Critical care medicine 39.5 (2011): 952-960.
