SQL performance tuning for SMEs and industry teams
I help teams understand why SQL Server has slowed down, where the pressure is building and which changes will bring performance back with evidence behind each step.
- Sustained slowdown under normal load
- CPU, I/O or memory pressure with no clear cause
- Plans and indexes drifting over time
- Proof of improvement, not guesswork
Targeted performance intervention, not guesswork
Wait stats analysis
Identify what SQL Server is actually waiting on: CPU, I/O, locks, and memory, then address the real bottleneck instead of symptoms.
Execution plan review
Detect costly operators, implicit conversions, parameter sniffing, and cardinality estimation errors that silently degrade performance.
Index strategy
Find missing indexes, remove redundant ones, and design covering indexes that match your actual query workload.
Memory & tempdb pressure
Diagnose memory grants, tempdb contention, spills to disk, and configuration issues that cause intermittent slowdowns.
Configuration review
Check MAXDOP, cost threshold, memory allocation, compatibility level, and other server-level settings that affect every query.
Baseline & monitoring
Establish performance baselines and set up lightweight monitoring to catch regressions before they reach production users.
Evidence-based, not trial-and-error
Performance tuning without data is guesswork. I start by collecting the right diagnostics: wait stats, plan cache analysis, index usage stats, and I/O patterns. Then I build a clear picture of what's actually happening before changing anything.
- Diagnostic collection with minimal production impact.
- Root cause analysis with documented evidence.
- Prioritised recommendations ranked by impact and risk.
- Implementation support with before/after validation.
Common questions about performance tuning
How quickly can you diagnose a performance problem?
Most diagnostic assessments take 1–2 days. I review wait stats, execution plans, index usage, and resource contention to identify the root causes before recommending changes.
Do you work with Azure SQL or only on-premises SQL Server?
Both. I have deep experience with SQL Server on-premises and Azure SQL Database, including Azure SQL Managed Instance. The tuning approach adapts to each platform.
Will tuning require application changes?
Not always. Many improvements come from indexing, configuration changes, or query rewrites at the database level. When application changes are needed, I document them clearly for your development team.
Can you help with ongoing performance monitoring?
Yes. After the initial tuning, I can set up baseline monitoring and keep an eye on regressions over time so performance does not quietly drift again.
Ready to fix your SQL performance?
Tell me what's slowing down. I'll review the situation and tell you what I'd do, what it takes, and whether I'm the right fit.
