24/04/2019

Growing market for optimizing database performance

Performance Monitor for PostgreSQL is a new product on the software market. The application allows for precise identification of problem with the performance of processes that run in the PostgreSQL database.

Database monitoring for PostgreSQL
The ability to fast processing a large data volume directly affects business results. There is a need to increase the work efficiency of the systems. The use of monitoring software allows to achieve the expected performance indicators of applications and business systems. Performance Monitor allows to choose the most optimal execution plans. The application allows to quick find new SQL queries that are the performance problems’ source for a given PostgreSQL instance.

demo online
Reduction IT costs
The new DBPLUS software for performance monitoring of PostgreSQL instances has the same user interface as versions for Oracle and Microsoft SQL Server databases. Thanks to this, the implementation and configuration of the software can be made independently by administrators who deal with the database engines performance. By migrate the database from the Oracle to PostgreSQL environment it is possible to transfer the history of the monitored database with the history.

Big data online
The DBPLUS software is also used by business users. It supports the system analysts work and is used to manage the performance of complex data that report systems. It offers many analytical tools:

  • access to performance statistics for loads
  • queries’ analysis and their execution plans on the instance
  • determine the level of waits that occur in a given instance
  • presentation of performance trends
  • compare performance data for days and periods
  • access to information about user sessions
  • preview of locks’ details in the instance, spaces occupied by databases in the instance or details of objects where queries are performed

For advanced users, full customization of the tool’s operation is available. It is possible to change the parameters settings responsible for the monitoring service, including time of data storage in history, the frequency of snapchat execution or the monitoring for query plans. Users can define the operation of the Security module by setting access to each of the screens for dedicated people. Performance Monitor offers many tools to automatically find anomalies. In the alert management panel, it is possible to define notifications based on statistics, create your own alert definitions, define parameters that control the collection of data on alarm events or configuration of email notifications.

Functionality of Performance Monitor software for PostgreSQL

Software features
Analysis of historical trends allows to compare performance in a very wide range of dates. This allows access to information on how SQL queries (currently cause of the problem) have behaved in the past. The tool also studies trends in the long term to avoid performance problems in the future.

DBPLUS Performance Monitor does not require installation of any software on monitored databases. The system logs into databases at 15-minute intervals and collects performance statistics. The load of monitored instances is invisible. The application tracks the instance’s performance by monitoring active connections, collecting information about wait and locks that are responsible for long execution of queries. Monitors slow queries, IO readings, and other performance statistics (cache hit rate, disk usage, buffer reading, etc.).

The application includes an alarm module for events that affect PostgreSQL instance performance. The tool has many defined alert rules based on performance statistics. Performance Monitor constantly monitors any deviation from the set trend and provides information to the administrator in real time.

DBPLUS Performance Monitor monitors PostgreSQL 9.4 and higher.

Test the software:
You can download a fully functional test version of Performance Monitor in the PostgreSQL version.

User’s manual
The user documentation describes in an accessible way all the functions available in the software.

Technical Specifications:
The DBPLUS Performance Monitor server runs on Windows Server 2008, 2012 or 2016 or Windows 7/8/10 with IIE and .NET 4.0 Framework. No Client software required, supported browsers: Internet Explorer, Edge, Chrome, Firefox, Opera.

Main application screens:

Artur Boguszewski

Artur Boguszewski

Software Architect