09/04/2020

New version Performance Monitor (release 2020.1)

On March 31, 2020 we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases. The most important functions added in the application are: mechanism for formatting and parsing queries for SQL Server, the ability to quickly go to session history from each screen, new performance statistics for Oracle and collecting information about interrupted queries in SQL Server.

Quick transition to the session history screen
In the new version of the application we have added the ability to quickly go to session history for a given query hash. The functionality is available on every window in which query identifiers are visible. Easy transition to session history allows you to significantly speed up the analysis and find the source of performance problems.

Query parsing mechanism and SQL Format
In the new version of the application for SQL Server databases, we have added a mechanism for formatting and parsing queries run on the monitored database. The mechanism allows you to quickly format a query and group its components, making it easier to analyze its syntax. In addition, the option to format query text has been added for each platform.

New performance statistics for Oracle
We have added information containing additional statistics containing detailed information about the duration of queries broken down into elements: Application wait Time, Concurrency wait Time, Cluster wait Time, User IO Wait Time, PLSQL Exec Time, Java Exec Time. Thanks to this it is possible to check the share of individual elements in the total duration of Elapsed time queries performed in the monitored database.

Collecting information about interrupted queries in SQL Server
In the new version we have added the functionality of monitoring interrupted queries. Interrupted queries are those that were started on the database (they used CPU database resources, memory, etc. during processing), but were not successful. Monitoring involves collecting information about the following queries:

  • terminated manually by the user,
  • timeout by the SQL engine e.g. as a result of a long block,
  • timeout due to deadlock,
  • interrupted manually while waiting in the lock.

Access to software updates
The DBPLUS software is updated at least 4 times a year. Customers have access to all updates when they have a license or maintenance service. With the upgrade to the latest version, the application will run faster and smoother. Each published version provides new functionalities that allow for easier management and performance improvement in the monitored database.

 

Detailed specification about changes in version 2020.1:

The user documentation describes in an accessible way all the new functions available in the software

Oracle:

Microsoft SQL Server

Wersja dla PostgreSQL:

Artur Boguszewski

Software Architect