Sonja Chevre

Sonja is a Technical Product Manager for Dynatrace Application Monitoring. She has a broad technical expertise acquired from more than 15 years working in IT. Contact her at @SonjaChevre

Sonja Chevre's articles

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

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