Monitoring results are usually difficult to persist. After a complex performance analysis of a large database system, the question and problem often arises as to how the findings and their data can be saved in the short or long term. The challenge Often the only possibility is to extract the data and graphics from the monitoring solutions and store them in a dedicated way, e.g. as a screenshot or in the form of a file with raw data. If you don't extract the data manually, you run the risk of not finding the data in your monitoring solution after a certain period of time and thus losing it. How can I persist panels using Speedgain for Databases? Speedgain for Databases with Grafana provides the ability to persist entire dashboards for a specified time frame and set an expiration date for automatic deletion. The snapshot feature allows for easy storage and retention of entire dashboards, including all data and displays for a specified time period. These snapshots can be accessed via a link without logging in, making them easily shareable. The retention period of the snapshot can be selected dedicately, so that they are deleted after a day, a week, or never. The display and analysis based on a snapshot is no different from a display of live data. So all functions, diagrams and charts are available, with the exception of the period change. In addition, you no longer run the risk of losing important monitoring results over time due to internal deletion processes. The benefits at a glance: Dashboards can be persisted for specific time frames Anytime? Adjustable expiration date with automatic deletion or no deletion Easy sharing Risk of losing important monitoring data is minimized Conclusion Speedgain for Databases provides an easy way to persist and share entire dashboards with their data. The risk of lost monitoring data of certain analysis results is therefore no longer present. If you have any questions, please feel free to contact us. We invite every interested DBA and production manager to check out Speedgain for Databases and download a trial version. Learn more about the benefits of Speedgain for Databases in our blog.

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.

Monitoring solutions typically offer a fixed, standard scope that, while mapping the needs of the average user, is difficult or sluggish to customize. With customizable dashboards - like those offered by Speedgain for Databases - you get all the views you need. The challenge The customer often has specific needs and requirements for the scope of a monitoring solution. If for customer A the values x, y, and z are relevant for stability, for customer B it may be the values a, b, and c. If necessary, this may even differ from database to database for one customer. Combinations or extrapolations of values are also often helpful for customers. For the monitoring of a DWH database it can be of interest to show the activities of reporting users, who can create individual reports on demand, separately from the daily recurring activities of batch users for the management of the database or for the automated creation of reports. However, the standard functions of monitoring solutions are usually not sufficient for SLA reporting to prove compliance with service level agreements, or for evaluations of the growth of certain tables or tablespaces, or for calculating the share of a certain application in the use of database resources to support accounting. Therefore, a more flexible solution is needed. What solution does Speedgain for Databases offer? Speedgain for Databases offers the possibility to create your own dashboards with trend charts and integrate them directly into the tool - without having to wait for a release. By using Grafana in the presentation layer, we offer customers a solution that can be easily and flexibly extended with dashboards. The Speedgain for Databases backend already provides the data for the dashboards in a PostgreSQL database. In addition to detailed performance information on all monitored databases, system information on the database servers and status information on the monitoring itself are also available there. Our included dashboards can serve as a template to compile new dashboards for specific requirements. The advantages at a glance: Availability of comprehensive performance, system and status information Individual customizability of the dashboard Clarity of presentation - you quickly get an overview of the metrics that are relevant to you. More efficient work with customized information Diverse reporting options Conclusion Due to the flexibility in the presentation layer, Speedgain for Databases is quickly and easily customizable by the customer and can be tailored and extended to meet specific requirements. The individual customizability of the dashboard makes it possible to visualize the key figures that are relevant for you and to prepare meaningful reports in a simple and understandable way. If you want to learn more about other 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.

Setting up monitoring is a major effort in large production environments, as the configuration often has to be adjusted for each individual database. With Speedgain for Databases, there is an option to monitor databases based on predefined policies. This conveniently reduces the time required and the error rate. The challenge In large production environments with many databases, there are three main challenges when configuring monitoring: 1) It must be possible to configure monitoring for a new database as efficiently as possible. 2) When monitoring settings are changed, it should be possible to do so in a simple way for a large set of databases. 3) Basically, the risk of misconfigurations should be minimized and a reasonable monitoring setting should be found for each database type. For this purpose, the DBA should be able to fall back on predefined proven standard settings. All these three points are cumbersome in most tools, since the parameters usually have to be set individually for each database and the DBA is hardly supported in this. What are the benefits of monitoring policies? Monitoring policies allow the creation of universal configurations for different types or groups of databases, but also allow for dedicated customizations. What solution does Speedgain for Databases offer? Speedgain for Databases comes with a predefined set of policy templates for different classes of databases. For example, there are different templates for Db2 and PostgreSQL databases. From these templates, new individual policies for special groups of databases, such as an OLTP database or a datamart, can be derived very easily. The definition of policies for entire database groups drastically reduces the administrative effort. New databases can easily be assigned to a policy without complex configuration. Likewise, customizations are quickly implemented even for a larger number of databases of the same type, since only the policy for this database type needs to be adapted. Customization for each individual database is not required. The advantages at a glance: Fast configuration of new databases and simple adaptation of existing database configurations using policies Reduced administration effort Reduced susceptibility to errors Conclusion New monitoring requirements can be responded to quickly and comprehensively. If, for example, production databases need to be monitored in more detail due to an acute problem, this can be successfully completed within a few minutes by adapting just one policy for all databases. Even when adding new databases to the monitoring, no complex configuration is required, as only one policy needs to be selected. 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 every interested DBA and production manager to check out Speedgain for Databases and download a free trial version.

Database monitoring solutions help database administrators monitor the health of their system and highlight problems in its operation, ensuring good system performance and preventing outages. With the ever-increasing number of critical databases and the need to monitor database systems from different vendors, organizations face hurdles that must be overcome. The challenge Adding new database systems to monitoring by a monitoring tool can involve additional installation work, for example, to install agents and monitoring scripts. Not only does this cost time, but it may not even be possible for the database administrator (DBA) to do it himself, because he lacks the permissions to install agents on the servers, for example. In this case, other departments would have to be involved, which further increases the time required and creates additional sources of errors. Agentless monitoring, as offered by Speedgain for Databases, can reduce this effort. What is agentless monitoring? Agentless monitoring essentially refers to using remotely callable built-in functions of the system being monitored, rather than installing additional utilities on the target system. What are the benefits of agentless monitoring with Speedgain for Databases? Our holistic database monitoring tool Speedgain for Databases works completely agentless. It is currently suitable for monitoring Db2 and PostgreSQL databases and will support other databases in the future. Only the Speedgain Collector and a component for providing REST services for the web frontend need to be installed once on any central server (but not on the systems to be monitored). Databases can be included in monitoring and analyzed in the web frontend without additional installations on the database servers. The web interface offers the possibility to include database systems including operating system data in the monitoring directly and without additional tasks. For example, the cataloging of a new database, which is common in the Db2 environment, is not necessary for monitoring. The time savings and risk are considerable compared to agent-based monitoring solutions. In addition, the risk of errors is significantly reduced due to the ease of installation. Furthermore, these advantages also apply in case of maintenance activities on the components, since only the central component and no decentrally installed agents need to be updated. The advantages at a glance Fast installation: Agentless monitoring can be easily and quickly installed centrally. Agent-based monitoring, on the other hand, requires agents to be deployed on each server. Easy maintenance: Database monitoring solutions help database administrators monitor the health of their system and highlight problems in its operation, ensuring good system performance and preventing outages. With the ever-increasing number of critical databases and the need to monitor database systems from different vendors, organizations face hurdles that must be overcome. Conclusion By easily integrating databases into an agentless monitoring tool, they can be included in monitoring more quickly. Database administrators not only save time during installation, but can benefit from using Speedgain for Databases at an early stage to identify and fix problems faster. If you would like 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 cordially invite every interested DBA and production manager to check out Speedgain for Databases and download a free trial version.

The performance monitoring solution Speedgain for DB2 is now available on Docker Hub. This is the easiest and fastest way to deploy our lightweight and feature-rich Db2 monitor in your on-premise or cloud environment! We enriched the standard Speedgain Collector application with several scripts to automate and control the complete process from installation to running in the background. You are only one step away from running your Speedgain for DB2 system in a couple of seconds! The Docker image is based on the official IBM Db2 Docker image that is already servicing lots of Db2 databases all around the world. Be one of the first to pull the image, that by way includes a trial license valid until 31stof March 2020. Visithttps://hub.docker.com/r/itgainis/speedgainfordb2for more details on how to run the image.

Highlights in Speedgain for DB2 V5.2 Revised Zoom Page Speedgain Indexes Module improvements Support for DPF Refined filter option in the Speedgain Client Speedgain SQL Workbench improvements UI revise for more comfort and usability Enhanced support for Virtual Indexes Create and manage Virtual Indexes during access path analyzes Generate a benefit analyzes for virtual and real indexes of an access plan Bulk DDL generation for multiple virtual indexes of a single access plan Export and Import of access plans Improved HADR Monitoring DB2 v11.5 support read more –ITGAIN Speedgain V5.2 whats new