SQL Server Performance Tuning
Budget: ₹37,500 – ₹75,000 INR
I’m looking for fresh eyes on several SQL Server queries that have gradually slowed as our data volume and complexity have grown. The workload touches both transactional tables and reporting aggregates, so the statements pull from mixed data types and heavily joined views.
Your first goal is to squeeze out every millisecond you can: inspect execution plans, identify missing or unused indexes, rewrite the worst-offending T-SQL, and verify statistics are up to date. I’ll give you a copy of the current schema, sample data, and the slow queries along with their existing run times so you can benchmark improvements on your side before we deploy to production.
Deliverables
• Revised or newly written Sql scripts
• Index and configuration recommendations with rationale
• Before-and-after performance metrics (elapsed time, logical reads, CPU)
• Short hand-off note so my in-house team understands the changes and how to maintain them
If you routinely work with SQL Server Profiler, Database Engine Tuning Advisor, and execution-plan analysis, this should be straightforward. I’m ready to start as soon as you are and can test changes quickly on a staging environment.
Your first goal is to squeeze out every millisecond you can: inspect execution plans, identify missing or unused indexes, rewrite the worst-offending T-SQL, and verify statistics are up to date. I’ll give you a copy of the current schema, sample data, and the slow queries along with their existing run times so you can benchmark improvements on your side before we deploy to production.
Deliverables
• Revised or newly written Sql scripts
• Index and configuration recommendations with rationale
• Before-and-after performance metrics (elapsed time, logical reads, CPU)
• Short hand-off note so my in-house team understands the changes and how to maintain them
If you routinely work with SQL Server Profiler, Database Engine Tuning Advisor, and execution-plan analysis, this should be straightforward. I’m ready to start as soon as you are and can test changes quickly on a staging environment.