Performance Monitor (release 2019.1)

March 16, 2019, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most important modules added in the application are: Standby databases’ monitoring, wait level comparison and calendar navigator.

Standby databases’ monitoring
In the new version of the application for Oracle, the check Standby database status function has been added. The information was added in the new Standby ArchiveLogs tab at the database details. Standby database management is to verify the transfer process by the database log files. The page shows information about production database with the host name and SID of the database, the name of the last archivedlog file (for asynchronous mode) and the list of Standby databases and refresh status based on log files.

Calendar navigator
In the new version of the application for Microsoft SQL Server and Oracle we have added on most screens a new feature in the form of speed date dialing. After click the button user can choose between several options: Today, Yesterday, Last Week, Last 2 Weeks, Last 30 days, This Month, Pre-Month and Custom Range, which allows to quick select a range of dates.

Wait level comparison
In the new version of the application, a function that compares the wait level has been added. The modification has been added for an application that supports SQL Server and Oracle. Comparison is able from instance details in the Waits tab. Wait index comparisons can be made for a single or groups of waits. There are two comparison modes: Days Compare, which allows to compare individual days, and Period Compare, where the periods are compared.

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.1:

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

Oracle:

Microsoft SQL Server

Artur Boguszewski

Software Architect

How can you speed up database read queries

Before getting into the technicalities of speeding up your database read queries, the first step is always to have a clear understanding of what exactly you need. This might sound straightforward, but inefficient queries often begin with uncertainty about the data requirements. Knowing exactly what information is necessary for your application or analysis not only helps in crafting precise queries but also prevents the database from retrieving extraneous information, which can significantly slow down performance.

Data Observability

Too often when looking at the data we see just numbers – columns and rows that might seem meaningful on the surface but lack depth without proper context. Data observability changes this perspective. This approach is about understanding what the numbers really tell us about the health, accuracy, and vitality of our data systems.

Data observability isn’t just one thing – it’s an ability, or rather a way of monitoring your data’s health, accuracy, and overall usefulness. It’s what equips data teams with the essential tools they need in order to make sure that the data that’s driving business decisions is not only there but also high-quality, well-structured, and up-to-date.

20/03/2019