← DB Alchemy home

Focused engagement

SQL Server performance tuning

A paid investigation into one agreed SQL Server or Azure SQL performance problem. Find out what is slowing the application and what to change first.

How the investigation works

  1. Agree the scope

    Identify the affected workload, agree what improvement would look like, and decide what diagnostic evidence is available.

  2. Measure the problem

    Review the relevant plans, waits, reads, CPU or memory grants. Look at how the workload behaves under the conditions that trigger the issue.

  3. Prioritise the fixes

    Get a written diagnosis, recommended changes, and a way to validate the result. Agree separately on implementation if you want hands-on help.

Measured case study

When Fast Queries Collide

See how an execution-plan review uncovered a scan of almost seven million rows and how two targeted indexes and recompilation changed the result.

Read the case study
Before tuning
396 ms
After tuning
52 ms

Contact Neil

Tell me what’s slowing down

Tell me what users are seeing, when it started, and what you’ve already tried. We can discuss where to begin.