query plan cache bloat

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