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
Agree the scope
Identify the affected workload, agree what improvement would look like, and decide what diagnostic evidence is available.
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.
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.
