Insightful Database blocking monitor for JD Edwards
In this article, I bring to you a powerful way to monitor and report on Blocked process in database using JD Edwards Server manager REST API and powershell.
Audience: JD Edwards Enterprise CNC Administrators, System Administrators, Database Administrators, EnterpriseOne Developers
Requirements and Tools: Powershell, Fair understanding of JSON and JDE Server Manager REST APIs
Abstract
This paper explores the critical importance of monitoring and alerting for database locks within JD Edwards EnterpriseOne databases. Database locks, while essential for maintaining data integrity and consistency, can lead to significant performance issues if not properly managed. This paper discusses the mechanisms of database locks, the necessity of monitoring these locks, the advantages of early detection, and the potential adverse effects of failing to address lock-related issues promptly.