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?
11/04/2024
The Easy Way and the Hard Way to Optimize an Oracle Database
It may seem that the companies entangled in the web of Oracle and its ecosystem have a limited set of options when it comes to performance tuning. It’s either – pay for extra functionalities and navigate Oracle’s complex licensing, risking non-compliance penalties. This often leads to a conservative approach to optimization, stifling innovation due to the fear of overstepping licensing terms.
But do we always have to go the hard way?
There’s a much simpler route that doesn’t involve trembling with fear of clicking the wrong thing. That’s what we will be talking about today.
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…
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.
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.
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,…
03/07/2019
CIOs will talk about database performance
Optimizing database performance and matching IT architecture to real-time data processing will be the theme of this year’s edition of…
05/04/2019
DBPLUS at the mbuf congress in Karlsruhe
Congress is a meeting of nearly 200 member companies from the IT industry and a popular network platform. Mbuf is…
28/12/2018
SQL Saturday in Linz, Austria
SQLSaturday is an all-day conference and training event which is taking place Friday, January 18, 2019 for the sixt time…
14/12/2018
IT Tage 2018 in Frankfurt
We spoke during the Frankfurt IT Tage 2018 about SQL Query Performance Monitoring and Analysis under Oracle and Microsoft SQL…
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.
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.
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.
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.
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.
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…
07/01/2020
Performance Monitor (release 2019.4)
On December 31, 2019, we released a new version of Performance Monitor for Oracle and Microsoft SQL Server databases. The…
16/10/2019
Performance Monitor for Oracle & MS SQL (release 2019.3)
On October 11, 2019, we released a new version of Performance Monitor for Oracle and Microsoft SQL Server databases. The…
03/09/2019
Performance Monitor for PostgreSQL (release 2019.3)
On August 31, 2019, we released a new version of Performance Monitor for the PostgreSQL database platform. The most important…
09/07/2019
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…
20/03/2019
Performance Monitor (release 2019.1)
March 16, 2019, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…