, , , ,

Successful Cloud Migration Tip: Eliminate excessive SQL

I’ve been blogging about excessive SQL executions for the past 10 years – since the time I have been working for Dynatrace. Whether it is the N+1 Query Pattern, inefficient SQL loading too much data, no caching of static data or…
, , , ,

Fixing SQL Server Plan Cache Bloat with Parameterized Queries

Developers often believe that database performance and scalability issues they encounter are issues with the database itself and, therefore, must be fixed by their DBA. Based on what our users tell us, the real root cause, in most cases,…
, , , ,

Diagnosing Common Bad Micro Service Call Patterns

In our previous article Harald and I covered how to diagnose common database performance hotspots in your Java Code. In the current article we focus on patterns that cause performance and scalability issues in distributed “Micro”…
, , , , , ,

Using Bind Variables to Improve Oracle Database Performance

While there are several ways to Improve Oracle Database Performance, Inefficient Database Access Patterns are among the top reasons why applications suffer from bad performance. Besides executing too many SQL Queries (N+1 Query Problem) or implementing…
, , , , , ,

Diagnosing Common Database Performance Hotspots in our Java Code

When I help developers or architects analyze and optimize the performance of their Java application it is not about tweaking individual methods to squeeze out another millisecond or two in execution time. While for certain software it is important…