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/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…
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…
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…
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…
06/07/2018
DBPLUS partner webtelligence on SQLSaturday in Paris
On July 7, 2018, the sixth Microsoft Data User Community meeting in France will take place. Participants will meet in…
12/06/2018
webtelligence at SOUG Day in Baden, Switzerland
The meeting of the Swiss community of Oracle users will take place on June 14, 2018. Our partner webtelligence will…
15/05/2018
A new DBPLUS Client in Austria
In May 2018, webtelligence, a German business partner of DBPLUS, began implementing the DBPLUS Performance Monitor solution for MS SQL…
16/04/2018
Another success for DBPLUS in the German market
On April 12, 2018, we began implementing the DBPLUS Data Replicator solution for the customer in the financial sector in…
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/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…
10/07/2022
New version Performance Monitor (Release 2022.2)
On July 10, 2022, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…
10/04/2022
New version Performance Monitor (Release 2022.1)
On April 10, 2022, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
30/12/2021
New version Performance Monitor (Release 2021.4)
On December 30, 2021, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
08/10/2021
New version Performance Monitor (Release 2021.3)
On October 8, 2021, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….