database performance

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, is inefficient data access patterns coming directly from their own application code or by database access frameworks they use. Developers can therefore solve database performance issues by simply  fixing their queries or correctly … read more

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” Service Oriented Architecture (SOA), such as transporting excessive quantities of data over a low latency connection, or making too many service calls due to bad service interface design, or thread/connection pool exhaustion. Here is … read more

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 Database Business Logic in the App (as compared to using Stored Procedures) developers often fail to use Prepared Statements and Bind Values which can drastically speed up SQL execution as the database can create and … read more

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 to optimize on milliseconds I think this is not where we should start looking. I analyzed hundreds of applications in 2015 and found most performance and scalability issues around bad architectural … read more