Performance Monitor (release 2018.4)

December 21, 2018 we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most important functions added in the application are: management of SQL objects, alerts module and presentation OS statistics.

SQL Outline/ Baseline/ Profile Management (Oracle), Plan Guides (SQL Server)
In the new version of the application for Oracle, you can manage objects such as Outlines, Baselines, Profiles. You can search for objects and queries related to objects. A Plan Explorer module has been added for SQL Server. That module allows to manage Plan Guides objects. The module contains the full information about objects changes and their history from the time of implementation.

Anomaly Monitor
In the new version of the application, an alert management module has been added. Information about alerts has been gathered in one place. They are now available from the database (Oracle) or SQL instance (SQL Server) details in the Anomaly Monitor menu. The module makes it easier to view and manage alerts that occurred in a database level.

Security Management
In the Performance Monitor application, the functionality of managing access to screens and functionality has been modified. In the new version has been added a new level of privileges – PROFILE. You can assign permissions to the profile, and then you can easily transfer access by assigning the profile to a user or group of users.

OS Statistics
For the Microsoft SQL Server version, information about statistics collected at the operating system level has been added. The application provides information on data such as: CPU Cores, CPU number, Virtual CPU number, Idle Time CPUs, Busy Time (CPUs), User Time (SPUs), Sys Time (CPUs, IO Wait Time (CPUs), or Physical Memory (MB).

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 versions 2018.4.1 and 2018.4.2:

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

Oracle:

Microsoft SQL Server

Artur Boguszewski

Software Architect

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.

ORA-00600 Exposed: Understanding and Resolving Oracle’s Internal Error Code

The ORA-00600 error presents itself as a catch-all for a variety of unforeseen conditions that the Oracle database software cannot process normally. While not quite the apocalyptic “kiss of death,” it is certainly viewed with a mix of dread and resignation. It is Oracle’s not-so-subtle way of throwing up its digital hands and admitting that something has gone awry. And that something, wasn’t a thing that Oracle had every anticipated.

It could be said that encountering an ORA-00600 is a bit like hearing ominous rumbles from your car’s engine right after you’ve bragged about its reliability.

21/12/2018