Performance tuning and optimization
Diagnosis of resource bottlenecks and latency through wait stats, execution plans and indexes, with an action plan prioritized by business impact.
- Query and execution plan analysis
- Indexes, statistics and maintenance routines
- Instance and storage configuration
- Capacity and growth planning