Performance Monitor (release 2019.2)

On June 28, 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: non-performance Waits dictionary, new statistics in Load Tends and Compare and changes in the alert module.

New alerts definitions
In the new version for Oracle and Microsoft SQL Server, new alerts definitions have been added: inactive sessions, UNDO and Temp (Oracle), using Log and Tempdb (SQL Server). In addition, an alert that returns the result of the query (in grid form) previously defined by the User has been added. Everything is available in the Configuration> Alert settings> Alerts definition menu.

In the latest version of the application has been added the ability to set up the sending of information about alerts by email one by one for the given Reason. The email will contain the database/instance name and information about the reason for the alert.

New statistics in Load Trends and Compare
The latest version has been added new database statistics that can track the Load Trends. This information is in the Load Trends tab (details of databases). New statistics for Oracle platform: Sessions using Undo, Record Count in Undo, Undo Space Used, Sessions using sort and Sort Space used. New statistics for Microsoft SQL Server: Sessions using Tempdb, Tempdb space used, Log space used, Log Usage sessions, Log Usage record count. An IO Waits indicator has also been added for both platforms. It contains information about the level of Waits related to the IO. The information facilitates and accelerates the analysis of sources of potential performance problems.

The ability to manage the Waits dictionary
The ability to manage the Waits dictionary for Microsoft SQL Server and Oracle has been added. The dictionary is available in the Configuration> Settings> Waits settings tab. Configuration provides the ability to assign Wait to non-performance group. Add the Wait to the group will not count as performance Waits. This configuration is important to calculate the wait level for each snap in the Load Trends and Waits tab.

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

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

Oracle:

Microsoft SQL Server

admin

Business Development Manager

SQL Server Databases in Recovery Mode: Proven Solutions and Insights

When your database is showing in recovery in SQL Server, it’s like it’s caught in a cycle of endless loading. This holdup can slow down your entire system, making it hard to get any work done. Whether it’s due to an incomplete restore or a log that’s filled to the brim, various issues can cause this frustrating state. Let’s dive into what might be tripping up your database and explore how to get things back on track quickly.

Slash Your Cloud Database Bills: Proven Cost Optimization Tactics

Every silver lining has a cloud database, and in this case, it’s the bills that thunder down post-deployment. Indeed, 61% of enterprises chant the mantra of cost optimization, though the costs of cloud computing often spiral higher than expected.

What exactly is cloud database cost optimization? It’s our sherpa guiding us through the financial fog, ensuring we’re not pouring funds into the cloud abyss unnecessarily. It’s about fine-tuning our resources, so we pay only for the computing muscle we flex, ensuring our cloud ventures are both lean and mighty.

What’s New in DBPLUS Performance Monitor 2024.3

In the latest update of DBPLUS PERFORMANCE MONITOR, version 2024.3, we’re rolling out exciting enhancements and brand-new features. All are designed to elevate your database monitoring and management capabilities to the next level.

From real-time online monitoring improvements to smarter notification systems, we’re excited to walk you through what’s new, what’s better, and how these changes can make a big difference in managing your databases.

09/07/2019