Microsoft SQL Server & Azure SQL

SQL Server performance tuning.

Hands-on help with slow queries, blocking and timeouts. Work directly with Neil Alexander for a focused investigation or ongoing part-time DBA support.

Measured case study

When Fast Queries Collide

87%lower elapsed time

Before tuning396 ms
After tuning52 ms

Read the case study · Measured elapsed time for a single execution.

Services

How I can help

Start with a specific performance problem or reserve monthly time for ongoing database work.

Focused engagement

SQL Server performance investigation

Find out why a report, stored procedure or application workflow is slow and what to change first.

  • Investigate one agreed performance issue
  • Review execution plans, workload evidence and waits
  • Get written findings and a prioritised fix plan
Explore performance tuning

Ongoing engagement

Part-time SQL Server DBA support

Get hands-on database help from someone who already knows your environment and priorities.

  • Reserve monthly time for database work
  • Improve performance, maintenance and recoverability
  • Get help with T-SQL changes and data integrations
Explore monthly DBA support

From the execution plan

Ten results. Nearly seven million rows read.

A filtered index supplied better statistics at compile time. Combined with a targeted payment index and recompilation, it helped SQL Server choose a plan that avoided the scan.

See how the query was tuned
Rows read from one table before tuning
6.94M
Rows read from the same table after tuning
13

Your consultant

Neil Alexander

I run DB Alchemy from Norwich and work remotely with IT and software teams. My experience spans production SQL Server administration, Azure SQL, and the T-SQL that connects applications to their data.

I’ve managed a 4 TB production database and maintained and optimised more than 30 production Azure SQL databases for customer applications.

View Neil’s LinkedIn profile

Common questions

What should I bring to the first conversation?

A brief description of the affected workflow, when it slows down, and what you’ve already tried. If you have timings or an execution plan you can share, that helps.

Can you make the changes as well?

Yes. Implementation can be scoped separately once we know what needs to change and how to validate it.

Do you work with Azure SQL?

Yes. I work with both Microsoft SQL Server and Azure SQL.

Contact Neil

What’s happening with your SQL Server?

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