On December 31, 2019, we released a new version of Performance Monitor for Oracle and Microsoft SQL Server databases. The most important features added in the application are: mechanism for formatting and parsing queries for Oracle, analysis of execution plans for queries and a new version of Anomaly Monitor for MS SQL Server.
Query parsing mechanism
In the new version of the application for Oracle databases we have added a mechanism for formatting and parsing queries run on the monitored database. This is the first version of this functionality and will be developed by subsequent releases. Functionality, in addition to query formatting, presents and highlights objects (tables, columns, indexes) participating in the query. From now on, it is even easier to verify that the execution plan is correct and that all relevant columns are included in the indexes.
Analysis of execution plans for queries
On the SQL Details screen, we’ve added special support for queries for which we have many execution plans. On the Graph tab, a new type of Seperate plans chart has been added. This function allows you to view query statistics separately for each of the execution plans. By choosing this option, the data on the chart are presented separately for each of the plans, which makes it easier to identify the best of the execution plans.
Anomaly monitor for MS SQL Server
As part of the new version of the application for MS SQL Server, the Anomaly Monitor screen has been modified. The method of detecting problematic events as well as the graphic part of the site has changed. In addition, new and modified current alert definitions have been added. Anomaly monitor has been enriched with problem detection which additionally analyzes database performance at a given time and presents the result of this analysis in the form of a problem description.
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 2019.4:
The user documentation describes in an accessible way all the new functions available in the software
Microsoft SQL Server