Performance Monitoring

with Speedgain

Mainframe Tools

Minimize your mainframe costs

Speedgain for Databases

In my opinion, the most impressive thing about the new "Speedgain for Databases", besides its solid and comprehensive functionality, is its integration with Grafana. This makes it possible to create target group-specific dashboards, e.g. for management or developers, with simple means. In addition, as I am used to from ITGAIN, I am convinced by the extraordinary willingness to adapt the product to customer requirements."

Wolfgang Spitzlberger - DB Architect - Allianz Technology SE

SQLReplayer

“To certify new server infrastuctur or any significant changes we use the SQLReplayer from ITGAIN to reproduce our specific workload.“

Erik Bak-Mikkelsen,
Head of Cloud Operations, Moovel (car2go a subsidary of Daimler)

Mainframe-Linux-Migration

"In order to take on the project successfully, we brought in external support into our project team from the very beginning. This was a good decision, as we needed a team of specialists to supplement our own employees and carry out diverse tasks. Smooth changeover process using "resourceful tools". For the Mainframe-Linux-Migration, we lacked the program support for the changeover What seemed initially to be a huge hurdle actually became a success factor. ITGAIN tools are the right solution."

Achim Siebertz,
Bürgel Bereichsleiter EDV

DB2 Tools

"For the daily administration of a large number of databases, we need a DB2 tool that provides a clear overview and is easy to use. Speedgain has proved itself to be very good in this capacity. We also particularly appreciate our working relationship with ITGAIN's employees. Furthermore, long-term behavior and evaluation of SLA requirements and accounting information is one of the requirements of performance monitoring in business.“


The experiences of a database team working for an international automobile manufacturer

JCL interpreter J2U

With the help of the JCL interpreter J2U, provided by ITGAIN, batch jobs available in the new Linux environment could be implemented without being changed. "Without a suitable tool, we would have had to convert the JCL individually for all batch jobs into a Linux script language“, summarizes Mr. Häcker the issue.

Häcker,
Project Manager from KRZ Lemgo

OS Monitoring

"OS monitoring in conjunction with the status monitor gives us a complete overview of our database server. Through complete monitoring of the database server, we can now identity weak points in the operating system."

Markus Brüning,
GAD eG, responsible for DB2 LUW databases

Migration from DB2 for z/OS to DB2 UDB for Linux

The BWI provides credit rating assessments and financial information for businesses and private individuals in Germany. Goals of this project were a considerable cost reduction through the complete migration of all DB2 databass of the company from DB2 for z/OS to DB2 UDB for Linux.


TUI-Booking System

Succsessful linkage of the mainframe-based TUI-booking system with the internet-based travel agency booking system CETS

TUI InfoTec is a tourism focussed IT-service provider within the TUI-Group, Europe's leading tourism company. The TUI-Group includes over 200 tourism businesses - from travel agencies, to tour organizers and airlines, to hotel associations. In this sector, information technology is a key factor for success: complex data must be integrated and various systems within the groups need to be linked together.

The goal of this project was the establishment of a platform-neutral and structured interface for the TUI-booking system, based on XML, that would allow links with any desired system (including links via TUI-Internet access).


Euler Hermes Kreditversicherungs-AG

The Euler Hermes Kreditversicherung-AG is Germany's leading credit insurer and service provider for claims management. The goal of the project was a shift of the CRM database and the Tivoli database of the group from DB2 for z/OS to DB2 UDB under AIX in order to attain cost savings and improvements in performance.


Consolidation of data models of TUI Deutschland GmbH with those of Thomson Travel Group

The TUI AG is the largest tourism group worldwide. The best known trademarks of TUI AG, aside from TUI, include among others the formerly British Thomson Travel Group, now TUI UK.

The goal of the project was the consolidation of the data models of TUI Deutschland GmbH with those of the Thomson Travel Group for the Hotel Inventory, Contracting and Destination Database sectors.


Top-Topic

14.02.2023

Speedgain for Databases v1.3.5 now available!


Speedgain for Databases v1.3.5 now available!
 - SQL Server Queries, Indexes, Backup - Db2 Inflight SQL drill down - Enhanced UI/UX for config HowTo Migrate Docker Hub

06.10.2022

SQL Server Monitoring with Speedgain for Databases

The current release 1.3.0 Speedgain for Databases extends the power of Speedgain performance monitoring to SQL Server environments can now be monitored for the first time in addition to Db2 and PostgreSQL. For SQL Server monitoring, users can choose between 12 predefined dashboards that include performance counters, maintenance statistics, resource utilization, storage utilization, database growth and IO times. Starting with an overview up to detailed evaluations, the drill-down is also directly implemented for SQL Server. The first customers have already received the new version and are using the new functions. Together with them, new features and dashboards are created in a direct and continuous exchange.

01.12.2021

The new Speedgain for Databases is available!

Save costs with a central monitoring solution for various operating systems and databases. Increase monitoring efficiency with customized dashboards. Save time with agentless monitoring of Db2 and PostgreSQL. Minimize configuration complexity with policy-based monitoring.

25.01.2021

Speedgain V5.3 is available

Highlights in Speedgain for Db2 V5.3 / Revised Static SQL Monitoring / Speedgain SQL Workbench improvements / Maintenance Task now work parallelized / New Maintenance Status Overview / Bulk Update options for username and password (Client and Collector) / Export and Import Client configuration

30.11.2021

Panels persist with expiration date

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.

30.11.2021

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.

30.11.2021

Create custom dashboards with Speedgain for Databases

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.

30.11.2021

Policy-gestützte Überwachung von Db2- und PostgreSQL-Systemen

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.

30.11.2021

Save time with agentless monitoring of Db2 and PostgreSQL databases and other databases in the future

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.