Latest
Events
Products
Partners
Release info
Logical vs Physical Replication

18/07/2024

The Replication Dichotomy: Logical vs Physical Replication

There’s a peculiar habit among some database professionals occasionally to toss logical and physical replication into the same bin. One might as well say socks and shoes are the same because, after all, they both go on your feet, right? But as anyone who’s tried wearing socks in the snow can attest, similarities on the surface can hide a whole universe of differences between logical vs physical replication.

Blurring together logical and physical replication, or neglecting their differences can lead to inefficient data management strategies. Each method has its merits and ideal scenarios of use. Knowing just when to apply each one—understanding their unique roles in the spectrum of data management—helps avoid unnecessary workload, optimizes performance, and ensures data integrity.

Distributed Databases

11/07/2024

Breaking Down Distributed Databases: How Do They Work? When to Use Them?

Distributed databases—by storing data across a whole set of physical locations— allow organizations to manage data across multiple geographical locations with the semblance of a single unified system. What can companies gain with this choice?

Execution plan changes in SQL server

04/07/2024

Execution Plan Changes in SQL Server: Reasons and Solutions

Executions plan—complex maps charted by the SQL Server optimizer, dictate the most efficient route for data retrieval. However, the plans are not static. They morph and adapt, influenced by a host of factors ranging from data volume changes to system upgrades. Each of the execution plan changes in SQL Server has the potential to sway performance dramatically.

Understanding the reasons behind these shifts, and more importantly, how to effectively manage them translates to maintaining optimal performance in SQL Server environments.

The Domino Effect in the T10 Database on g1rush Server

27/06/2024

The Domino Effect in the T10 Database on g1rush Server

Performance issues rarely occur in isolation. Often, a single problem can trigger a cascade of related issues, each compounding the overall impact on the system. This case study explores such a scenario in the T10 database on the g1rush server. 

Overcoming Execution Plan Changes

20/06/2024

From Analysis to Action: Overcoming Execution Plan Changes

Execution plans choose the way in which SQL queries are executed by the database engine. As such, they are a difference between a smoothly running database and one that stumbles under load. Sometimes, an execution plan changes, for various reasons—often silently and without warning—and the far-reaching fallout can be huge.

The most immediate impact seen as the execution plan changes is a decline in query performance. A query that once ran smoothly in milliseconds might, due to an altered plan, start consuming seconds. This increase in query time can cascade into longer load times for applications, frustrated end-users, and severe financial repercussions in high-stakes environments such as financial trading platforms or real-time data services.

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…

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…

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.

Wichtige Faktoren in DevOps-Operationen

29/02/2024

Shifting Gears to Real-Time: How One Company Overcame Its Data Dilemma

Today’s story is about a leader in the automotive spare parts market, spanning 17 European countries, grappling with a significant challenge. They faced the daunting task of managing delayed reporting, ensuring consistency across diverse markets, and customizing reports with limited flexibility. This scenario led to delayed data updates. This, in turn, caused frustration and inefficiency.

Wichtige Faktoren in DevOps-Operationen

14/02/2024

Key Factors in DevOps Operations

Ensuring access to, optimizing and securing key data is essential to the smooth flow of information, crucial on the path to operational success. DevOps professionals face the challenge of sifting through data in search of relevant insights. In the face of widespread data breaches, maintaining database security while ensuring easy access becomes a priority. DBPLUS PERFORMANCE MONITOR offers a solution, enabling effective data management, analysis and security.

07/02/2024

In Pursuit of Optimized Performance: Unexpected CPU Load – Case Study

When our client’s sales application was paralysed and 28TB of data became unavailable, response speed was critical. This case study not only shows how quickly performance crises can occur, but also highlights the great importance of preventive measures and looking at the problem from different perspectives.

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…