Latest
Events
Products
Partners
Release info

04/04/2024

Performance Monitor (Release 2024.1)

In April 2024, we published another version of the Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL, and SAP Hana…

Cloud Databases

To Cloud or Not to Cloud: Pros and Cons of Cloud Databases

While big players have little to no choice but to go for the cloud, some businesses might weigh the choice between traditional on-premises setups and cloud solutions. On one hand scalability, flexibility, and cost savings that traditional databases struggle to match. The ability to scale resources up or down on demand, pay only for what you use, and offload maintenance and security tasks to experienced providers presents a compelling case for moving to the cloud.

On the other hand, traditional on-premises databases offer a level of control and security that some businesses are reluctant to use. The physical control over the database infrastructure can provide a sense of security, particularly for organizations with highly sensitive data or stringent regulatory compliance requirements. Additionally, for companies with stable data loads that don’t require frequent scaling, the initial investment in on-premises hardware might not seem as daunting.

Technical Documentation

28/03/2024

From Tutorials to AI: Approach Technical Documentation From a Different Angle

The only thing more abundant than coffee in a developer’s life is, well, technical documentation. It seems simple enough – you have a problem, you go through a few pages, and get your answer, that simple. Is it, though? Anyone who’s ever tumbled down the rabbit hole of Stack Overflow threads at 2 AM or squinted at API docs with the growing suspicion they’re written in an ancient, forgotten dialect will tell you: not quite.

Tutorials skip crucial steps, reference guides resemble dense textbooks, and help forums, while helpful, can send you on a wild goose chase for that one golden nugget of information. But there’s a light in the tunnel, and we’re here to help you find it.

Discover the intricacies of the 'IS NULL Condition' in SQL queries and learn effective optimization techniques to boost your database performance. This guide offers insights into overcoming common pitfalls associated with 'IS NULL' and enhancing query efficiency.

20/03/2024

‘OR’ and ‘IS NULL’ Might Be Holding You Back

Where “OR” and “IS NULL” condition frolic unchecked, queries often find themselves stumbling down the performance rabbit hole—a place where CPU cycles burn faster than a comet tail and I/O operations multiply with the fervor of rabbits in spring.

14/03/2024

The Nightmare of Database Deadlocks

A database deadlock occurs when two or more transactions in a database system hold locks on resources the others need. Each transaction waits for the others to release their locks, and just like two drivers who are not sure who has the right of way, none can proceed.

It would be lovely to be able to enumerate the causes of a database deadlock and address all of them. Sadly, it’s way too complex. It can be said, though, that a database deadlock is most likely to stem from poor application design, lack of proper transaction management, or the inevitable complexity of highly concurrent systems.

08/02/2021

Manage your database performance and data accessibility today…alive tomorrow.

Webinar date: Wednesday 10th March, 11:00am CET Your business growth demands efficient IT services with upgrades and enhancements delivered on…

16/09/2020

Actinium Consulting GmbH and DBPLUS enter into partnership

Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…

07/01/2020

dbi services with real-time replication using the DBPLUS Data Replicator

dbi services described our solution for real-time data replication on their blog. dbi services was founded in 2010 and is…

16/10/2019

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…

27/08/2019

DBPLUS will perform at a meeting organized by the Warsaw PostgreSQL Users Group

On October 10, 2019 in Warsaw at 5 Kolejowa Street, DBPLUS together with Goldenore and EnterpriseDB will talk about PostgreSQL…

The Most Important Database Performance Metrics

06/06/2024

The Most Important Database Performance Metrics

If no one sees the database issues, do they really happen?  – Contrary to the popular philosophical dilemma, this question can be answered quite easily – Absolutely yes. Unseen or unmonitored problems in database systems do occur and can indeed cause significant disruptions. It doesn’t matter if they’re not immediately apparent. Without monitoring of the database performance metrics and proactive management, these underlying issues can compound, leading to decreased performance, potential data loss, and even system failures that by their nature demand urgent and often extensive interventions to rectify.

The cost of ignoring database performance metrics is just too great.

Locks by Application Issues

23/05/2024

The Story of Locks by Application Issues

On the 20th of April, query load times usually ranged from 12 to 15 seconds per snapshot, but there was a notable spike exceeding 2,000 seconds during certain periods. This anomaly suggested a deeper issue, prompting a detailed investigation. By examining the correlation between locks and application issues, executions, disk reads, and buffer writes, a significant overlap was found between increased query durations and intensified locking issues. Accessing the lock history tab provided detailed data on each lock event, including the time, duration, and specific database elements affected.

speed up a database read query

02/05/2024

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

25/04/2024

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. 

Database Activity Monitoring

18/04/2024

How Busy Was the Database Today? – Database Activity Monitoring Done Right

Trying to gauge the workload of a database on any given day can pose quite a challenge. A straightforward question supported by basic Database Activity Monitoring might not yield an insightful answer if it’s stripped of context, cluttered with arbitrary numbers, and missing crucial details.

So, what’s the right way to address this query?

16/09/2020

Actinium Consulting GmbH and DBPLUS enter into partnership

Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…

31/03/2020

dbi services and DBPLUS enter into a partnership

Delémont, March 31, 2020 – dbi services has secured a partnership with DBPLUS, a software development company which specializes in…

16/10/2019

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…

16/07/2019

DBPLUS on “IT Tage” in Frankfurt

“Everything under one roof!” is the motto of the IT-Days 2019 from December 9th to 12th in the Cape Europa,…

17/06/2019

DBPLUS expands partner network

Another companies from the CEE region joined the group of DBPLUS partners. As a result, DBPLUS Clients gain access to…

04/04/2024

Performance Monitor (Release 2024.1)

In April 2024, we published another version of the Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL, and SAP Hana…

24/01/2024

New version Performance Monitor (Release 2023.4)

In December 2023, we released the next version of Performance Monitor application for Oracle, Microsoft SQL Server, PostgreSQL and SAP…

05/07/2023

New version Performance Monitor (Release 2023.2)

On July 5, 2023, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…

07/04/2023

New version Performance Monitor (Release 2023.1)

On April 7, 2023, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…

performance monitor

10/10/2022

New version Performance Monitor (Release 2022.3)

On October 10, 2022, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…