I will optimize slow sql server queries and entity framework core performance

Ahsan Noor

Pakistan

I speak English

Senior Dotnet Developer for ASP NET Core APIs, Integrations and Modernization

Senior .NET developer with 6+ years building enterprise backends in C#, ASP.NET Core and SQL Server. I design and fix Web APIs, integrate third-party services, tune Entity Framework Core and SQL perfo...
Read More
About this Gig

Pages loading slowly? Reports timing out? Very often the cause is a handful of inefficient queries, missing indexes or an Entity Framework pattern that sends far more queries than it needs to.


What I do:

  • Analyze execution plans for slow SQL Server queries
  • Rewrite T-SQL and stored procedures for efficiency
  • Recommend and script indexes (with trade-offs explained)
  • Fix EF Core issues: N+1 queries, over-fetching, tracking overhead
  • Rewrite LINQ so it translates to efficient SQL
  • Before/after timings measured on your data or a copy of it

What you get:

  • Optimized queries and/or C# code changes
  • Index scripts ready for you to review and apply
  • A short report: the issue, the fix and the measured result

What I need from you:

  • The slow queries or code paths
  • Database schema plus a test copy, or read-only access to a non-production environment
  • Approximate table sizes

I won't make changes directly on your production database. Results depend on your data and server, so I report real measurements rather than promising a fixed speed-up.


Also experienced with PostgreSQL. Message me first to confirm.

Read More
optimize slow sql server queries and entity framework core performance
Full Screen
optimize slow sql server queries and entity framework core performance

Database type:

Relational database

Platform:

MS SQL

•

PostgreSQL

Expertise:

Design

•

Normalization

•

SQL

•

Performance

My Portfolio

Related tags