The Progress database provides a multi-threaded database server that can service multiple network clients. Each server handles many simultaneous requests from clients. The server processes simple requests as a single operation to provide rapid responses; it divides complex requests into smaller tasks to minimize the impact on other users of the database.
For storage and retrieval of persistent data in an IT infrastructure, application components rely on database servers. A database server is responsible for reliably managing a large amount of data in a multi-user environment so that many users can concurrently access the same data. At the same time, a database server must also prevent unauthorized access and provide efficient solutions for failure recovery.
For ensuring high availability, performance, and security, a database server includes a wealth of data storage, caching, and retrieval functions. To ensure peak performance, a database server needs to be continuously monitored and tuned. Sometimes, there may be a sudden change in workload to the database, resulting in an increase in the number of simultaneously processed transactions. This scenario could result in a performance bottleneck at the database server. Continuous monitoring and optimization of the database server is essential for ensuring that the database server operates at its peak.
The eG Enterprise is programmed with a variety of tests that are designed to monitor the critical parameters of the Progress database servers. Let us now discuss how the eG Enterprise performs monitoring of the Progress database server in the forthcoming chapter.