A new version of DBPLUS Performance Monitor for Oracle and Microsoft SQL Server databases is available. 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.
For Oracle:
Installer Download:
http://dbplus.tech/dbplus/download/downloadDPMOracle.php?id=E6D4-C4I2-M4R0-H2C8Upgrade instructions in chapter 4 of the documentation:
http://dbplus.tech/dbplus/manuals/DPM_ORACLE_Users_Manual_EN.pdfWhats New of Version:
https://dbplus.tech/dbplus/releases/OracleReleaseInfo_2019.4_EN.pdf
For Microsoft SQL Server:
Installer Download:
http://dbplus.tech/dbplus/download/downloadDPMMssql.php?id=E6D4-C4I2-M4R0-H2C8Upgrade instructions in chapter 4 of the documentation:
http://dbplus.tech/dbplus/manuals/DPM_MSSQL_Users_Manual_EN.pdfWhats New of Version:
https://dbplus.tech/dbplus/releases/MssqlReleaseInfo_2019.4_EN.pdf