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. 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… 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

Five easy steps to improve your database performance

January 30, 2015: Based on reader feedback, section 4 “Do you have enough database connections?” has been revised. Database access is a core feature of most applications. Based on our experience, it seems that for at least 80% of all applications we see, simple database performance tuning can speed up applications significantly. Fortunately, there isn’t a lot of rocket science involved until you get really deep under the hood of… read more