Phoenix - Your AI AssistantOptimize slow SQL Server queries, stored procedures and indexes
Delivery in
3 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
Slow reports, timeouts or high CPU on your SQL Server / Azure SQL database? I will find the bottlenecks and fix them.
What's included:
- Analysis of your slowest queries and stored procedures using execution plans and wait statistics
- Rewriting heavy T-SQL (joins, CTEs, functions, cursors) for better performance
- Index review: add missing indexes, remove unused/duplicate ones, fix fragmentation
- Before/after timings so you can see the improvement
- A short report explaining every change
Why me: 4+ years of SQL Server development - advanced stored procedures, CTEs, UDFs, index optimisation and query tuning for high-volume e-commerce and CRM systems, including resolving live blocking and failing triggers under SLA.
This offer covers up to 5 queries / stored procedures. For larger databases, message me first for a custom quote.
What's included:
- Analysis of your slowest queries and stored procedures using execution plans and wait statistics
- Rewriting heavy T-SQL (joins, CTEs, functions, cursors) for better performance
- Index review: add missing indexes, remove unused/duplicate ones, fix fragmentation
- Before/after timings so you can see the improvement
- A short report explaining every change
Why me: 4+ years of SQL Server development - advanced stored procedures, CTEs, UDFs, index optimisation and query tuning for high-volume e-commerce and CRM systems, including resolving live blocking and failing triggers under SLA.
This offer covers up to 5 queries / stored procedures. For larger databases, message me first for a custom quote.
What the Freelancer needs to start the work
- The slow queries / stored procedures and roughly how long they take now
- Read access to the database (or a backup / test copy) and SQL Server version
- Actual execution plans if you can export them
- Any constraints (e.g. no schema changes, maintenance windows)