Browse categories
Explore
Fiverr Pro
English
$
USD
I will diagnose and fix sql server performance, blocking and deadlocks
Senior SQL Server DBA for Performance Tuning and Troubleshooting
SQL Server slow, unstable, or causing timeouts? I help businesses identify the root cause and restore performance. Senior Microsoft SQL Server DBA specialized in performance tuning, blocking, deadlock...
About this Gig
Is your SQL Server slow, blocking users, generating deadlocks, consuming high CPU, or causing application timeouts?
I will investigate the issue, identify the root cause, and provide clear, evidence-based recommendations with production safety in mind.
I can help with slow queries, stored procedures, blocking, deadlocks, high CPU, memory or I/O pressure, execution plans, Query Store, parameter sniffing, indexing, statistics, waits, TempDB contention, Extended Events, and SQL Server configuration.
My investigations follow my TRACE approach:
Triage Runtime Analysis Analyze Correlate Execute Recommendations
Depending on the package, you may receive root cause analysis, severity assessment, prioritized corrective actions, before/after metrics, reusable diagnostic scripts, preventive recommendations, and a professional technical report.
Direct server access is not always required. I can work from execution plans, XEL files, deadlock XML, Query Store data, logs, screenshots, and diagnostic outputs.
Find the root cause. Prove it. Fix it safely.
For production or complex environments, please contact me before ordering.
Platform:
SQL Server
FAQ
Do you need direct access to my SQL Server?
No. In many cases, I can perform the investigation using execution plans, Query Store data, XEL files, deadlock XML, diagnostic scripts, logs, screenshots, and DMV outputs. Direct access can be discussed if necessary.
Can you troubleshoot a production SQL Server?
Yes. Production troubleshooting is one of my main areas of expertise. I focus on evidence-based diagnostics and safe recommendations while considering performance, availability, risk, and business impact.
Can you analyze slow queries or stored procedures?
Yes. I can investigate execution plans, Query Store, indexes, statistics, parameter sniffing, logical reads, waits, CPU consumption, and other factors affecting query performance.
Can you investigate blocking and deadlocks?
Yes. I can analyze blocking chains, deadlock graphs, Extended Events, locking behavior, involved queries, transaction scope, and resource access patterns to identify the root cause.
Can you investigate high CPU or memory usage?
Yes. I can analyze expensive queries, waits, execution plans, Query Store, memory pressure, parallelism, compilation behavior, and other potential SQL Server bottlenecks.
What information should I provide?
Please provide your SQL Server version, a description of the issue, when it started, whether it is intermittent or continuous, and any available execution plans, queries, XEL files, deadlock XML, logs, screenshots, or diagnostic outputs.
Will you make changes directly on my production server?
By default, I provide the diagnosis and recommended corrective actions. Direct production changes should be explicitly agreed upon and performed with appropriate testing, safeguards, and rollback considerations.
Is my data confidential?
Yes. Any queries, database structures, logs, screenshots, execution plans, or technical information shared for the investigation will be treated as confidential.
Should I contact you before ordering?
Yes, especially for production incidents, complex performance issues, Always On environments, or investigations involving multiple databases or servers. This helps define the correct scope before starting.
