I will diagnose and troubleshoot your sql server performance issue
Senior SQL Server Specialist , 30 Years' Experience , Performance, RCA
About this Gig
When your SQL Server is slow, blocking users, or disrupting production, you need the root cause fixed, not another generic health report.
I provide senior-level SQL Server troubleshooting and performance tuning for businesses facing urgent or high-impact database problems.
I analyse the environment, isolate the bottleneck, implement one safe, targeted fix, and verify the improvement.
What you get
- Root-cause analysis for slow queries, blocking, deadlocks, failed jobs, or performance degradation
- One agreed corrective fix implemented safely
- Before-and-after performance evidence
- Rollback script or documented rollback procedure where applicable
- Clear explanation of what caused the problem
- Short technical handover with recommended next steps
Typical problems I investigate
- SQL Server suddenly running slowly
- Queries that previously ran fast now taking minutes
- Blocking or deadlocks affecting users
- High CPU, memory, I/O, or wait times
- Production database performance degradation
- SQL Agent jobs or database processes failing
Why work with me
29+ years in IT, including SQL Server, production support, performance troubleshooting, and L3 incident resolution in demanding enterprise environments pro
Database type:
Relational database
Platform:
MS SQL
Expertise:
Normalization
•
SQL
•
Performance
•
Query optimization
Other Databases Services I Offer
FAQ
1. What does the SQL diagnosis service cover?
One clearly defined SQL Server performance issue. I analyse the evidence you provide, identify the likely root cause, and deliver a remediation plan. Implementation and environment-wide analysis are not included.
2. What do you need from me to start?
Send a description of the issue, SQL Server version, expected behaviour, and available evidence such as query text, execution plans, timings, error messages, Query Store output, screenshots, or relevant logs.
3. Do you need access to my production database?
Not always. Many issues can be diagnosed from queries, execution plans, Query Store data, logs, and other evidence. If live access is needed, we will agree on the appropriate approach before work begins.
4. Can you work with on-premises and cloud SQL Server?
Yes. I can investigate SQL Server running on-premises, on virtual machines, or in cloud environments. Please provide your SQL Server version and hosting environment when describing the issue.
5. What if the issue is not SQL-related?
If the evidence shows SQL Server is not the root cause, I will document my findings and explain where the evidence points. Ruling out SQL Server is still a valuable outcome of root-cause analysis.
6. Can you investigate more than one issue?
The service is scoped by the number and complexity of issues and remediations purchased. If you have several unrelated problems or need an environment-wide assessment, please contact me before ordering.
7. Can you guarantee a specific performance improvement?
Performance gains depend on the root cause, workload, data and environment. I focus on measurable improvement and, where possible, provide before-and-after evidence rather than promising an arbitrary percentage.

