Subscribe
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.
30/05/2024
The Toughest Challenges and Problems with Oracle Database
As of today, the Oracle database is still the most popular database out there, with a rating score of 1,240.88. Considering all of the factors – its powerful and comprehensive features that cater to large-scale enterprise needs, it comes as no surprise.
However, having managed and used numerous Oracle databases over time, we’ve observed several recurring frustrations — problems with Oracle database that can pose significant challenges for its users. From the complex and often opaque licensing structure to high costs and aggressive sales tactics, taking care of the Oracle ecosystem requires constant awareness and a willingness to adapt, at any second.
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.
16/05/2024
Why Oracle Changes the Execution Plan for a Query?
Understanding why Oracle changes the execution plan for a query can save you a lot of time and headaches. Statistics, data distribution (even without updated statistics), schema changes, and much more — There are numerous factors behind the changes of the execution plan. Having a grasp on all of them helps maintain efficient and stable query performance.
09/05/2024
BLOG – 10 Mistakes Committed by Inexperienced Programmers in Relation to Databases
From the basics of understanding SQL and its impact on databases, to the importance of maintaining clear Service Level Agreements and performance baselines, this article sheds light on critical areas often overlooked by newcomers.
16/02/2018
DBPLUS at the DOAG/Oracle Data Analytics Conference 2018 in Brühl, Germany
Data Analytics 2018, which was previously known as the “Oracle Data Warehouse Conference,” took place this year on March 19…
18/01/2018
DBPLUS is the Silver Sponsor of SQLBits
SQLBits is the largest SQL Server conference in Europe for data professionals. It provides the education, skills, and solutions from…
03/01/2018
DBPLUS at SQLSaturday #679 in Vienna
SQLSaturday is an all-day conference and training event which is taking place in 2018 for the fifth time in Austria….
10/10/2017
webtelligence to show DBPLUS portfolio at SQLdays conference October 10-11, 2017
ppedv AG invites to SQLdays 2017 in Erding, just to the east of Munich Airport. Numerous experienced speakers will present…
11/05/2017
DBPLUS partner – webtelligence IT consulting GmbH as a speaker and exhibitor at the mbuf
It is one of the highlights within the German IT industry: the regularly held mbuf annual conference . Both members,…
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…
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.
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.
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…
14/11/2024
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.
22/08/2024
Performance Monitor Changes in Version 2024.2—Part I: Online Monitor
Statistics can lie—” The only statistics you can trust are those you falsified yourself” This old adage attributed to Sir Winston Churchill rings especially true if you’re dealing with daily database monitoring. When data is only captured in 15-minute intervals, transient issues that can severely impact performance might slip through the cracks, unnoticed and unaddressed until they’ve already caused significant problems.
In the newest release of the DBPLUS PERFORMANCE MONITOR, we’re extremely excited to show you the solution that the new functionality brings to the table.
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…