Monitor operating system, PostgreSQL and Db2 with only one tool
Ensuring good system performance is essential for any modern software system. For this reason, there are individual monitoring solutions on the market for almost all basic components such as the operating system or database. The problem is that these solutions usually only look at one component, such as a specific database. In this case, several monitoring applications have to be used for a complete picture. This means working with different UIs without a comprehensive and consistent representation of the overall performance data. Finally, the variety of monitoring tools costs database administrators many man-hours that could be used more efficiently.
The challenge
Larger users typically have databases from more than one vendor in use. If the monitoring and analysis is done by software that is tuned to exactly one vendor, a multitude of monitoring solutions quickly accumulates. In addition, there is often separate monitoring for the operating systems used. This makes it difficult to work efficiently and hinders the detection of more complex problems.
However, it can be crucial for the analysis not only to know how the different memory areas of the database are used, but also to know the memory utilization and possible swapping in the operating system.
External problems, such as SAN connectivity, can also be identified more quickly if it is possible to see at a central point that similar problems are occurring simultaneously in different database systems. In addition, using multiple monitoring solutions also increases the cost and effort required to maintain them.
What is Speedgain for Databases' solution?
Speedgain for Databases addresses all of these issues by providing comprehensive analysis capabilities for operating system metrics, Db2 and PostgreSQL database metrics. Other database vendors as well as additional KPIs, for example on network metrics, will be added in future releases.
By using Speedgain for Databases, only one tool is required. This reduces complexity, maintenance and training efforts while increasing efficiency in monitoring and problem analysis.
The benefits at a glance:
- Comprehensive analysis options
- Support for various databases (currently Db2 and PostgreSQL databases; other vendors will be added soon)
- Complexity, maintenance and training efforts are reduced by the one-tool solution, which also saves valuable man-hours
- Increased efficiency in monitoring and problem analysis due to a consistent and clear presentation of performance data
- Reduction of TCO (total cost of ownership)
Conclusion
Speedgain for Databases provides a comprehensive view of monitoring data from different components. It quickly identifies problems, thus increasing the availability and performance of the overall system and also optimizing the TCO (total cost of ownership).
If you want to learn more about the benefits of Speedgain for Databases, take a look at our blog and stay up to date.
If you have any questions, feel free to contact us. We invite any interested DBA and production manager to check out Speedgain for Databases and download a free trial.
