Summary
One of the challenges of the DBA’s role is to evaluate the impact of changes they make to code or data structures on a busy, production system. While tuning a single query in isolation offers easy metrics such as elapsed time or logical reads, making minor tweaks on a busy system may require deeper evaluation.
Azure SQL is a deeply instrumented software and allows for monitoring at several levels.
Learning objectives:
Now that you've reviewed this module, you should be able to:
- Describe wait statistics
- Understand important aspects when tuning indexes
- Explore when to use query hints