database monitoring

Monitoring ASP.NET Core applications

One of the hot topics currently in the .NET community is CoreCLR and ASP.NET Core. As most probably you already know: Microsoft decided to create a cross platform, high performance version of ASP.NET, which they even open-sourced. What is ASP.NET Core? There are many great posts about the basics of ASP.NET Core, so in this post we do not talk about the programming model and the differences between ASP.NET Core … 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