New version Performance Monitor (release 2020.2)

On July 9, 2020, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases. The most important functions added in the application are: shared Dashboard, database object size monitor for Oracle and SQL Server, forecasting object size analysis and query explorer for Oracle and SQL Server databases.

Shared Dashboard
The new Dashboard screen allows you to simultaneously view all databases from each version of the DBPLUS application (Oracle, SQL Server and PostgreSQL) on one screen. The screen presents the most important performance statistics compared online to the trend calculated for a given database. The dashboard also presents information about alerts, which significantly shortens the response time to problems in a given database.

Object Size Exlplorer – size monitor
In the latest version, we have added the functionality of collecting information about the size of objects in the monitored database (Oracle, SQL Server). From now on, it will be possible to verify the space size by a given object over time.
Collecting information about the size of objects is a function launched on demand by the user (disabled by default). The data on objects size are collected at two-hour intervals and saved to the repository database.

Forecasting changes in database size
In the latest version of the application, we have introduced the functionality of predicting the use of disk space in the database. This functionality will easily help each database administrator to predict the size of the database and facilitate the Capacity Planning process. Forecasting the database size is calculated on the basis of data collected by DBPLUS applications and stored in the repository database. Forecasting can be made on the basis of historical data from the last 3 or 6 months as well as the entire year.

Query Object Explorer – query monitor
In the latest version, we have introduced the ability to analyze query objects – Object Explorer. The functionality allows you to analyze in detail the objects that are part of a given query, which means it speeds up the performance analysis, e.g. whether the optimal index is used in the query. The functionality is especially useful in the case of queries based on views, thanks to Object Explorer it is easy to obtain information about assigning a column in a query to a dedicated table from a view.

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 2020.2:

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

Oracle:

Microsoft SQL Server

PostgreSQL:

Artur Boguszewski

Software Architect

Databases in 2025: New Architectures, Smarter AI, and Stronger Security

The year is 2025, and the databases that once seemed so clever have gotten old and cranky. They’re no longer content with sitting there, quietly holding onto rows and columns like good little librarians. Nope. Now they’ve got opinions. They’ve got styles. They’ve got ideas about how to organize themselves, how to spread out across the clouds, how to speak human language, and how to lock the door behind you when you’re done rummaging through their shelves.

The old way of doing things — shoving everything into a single warehouse and hoping for the best — is about as appealing as canned spinach. So, what will we do instead?

The Intersection of Quantum Computing and Database Management

Databases are the engines powering our digital age, storing, managing, and retrieving the vast amounts of data generated every second. For decades, they’ve relied on classical computing to do the heavy lifting, using algorithms and hardware that have become increasingly optimized but still face fundamental limits. As datasets grow larger and more complex, and as the demand for real-time insights and advanced security rises, it’s becoming clear that classical systems alone may not be enough to meet these challenges. What then? Two words: quantum computing.

ORA-12154: TNS:Could not Resolve the Connect Identifier Specified

Encountering the ORA-12154 error can halt productivity and disrupt critical database operations. This error arises when Oracle cannot resolve a specified connect identifier, often due to configuration oversights or network issues. Without an understanding of the root causes, users find themselves stumbling in the dark, trying to rectify an issue without knowing where to start

05/08/2020