The tool also allows for several troubleshooting approaches,
such as Top-down wait statistic analysis (Start with waits categorizes and end up correlating wait to code which generates it.)
.png)
Top resource-intensive query tuning.
Based on aggregated data, tune the most influential code.
Order your results based on performance attributes such as CPU, Duration, Reads, etc.., then focus on the most resource-consuming code.
The bottom-up tunning approach
is based on challenges we already know from the server.
Baseline trend comparison.
Useful for troubleshooting challenges identified based on trend change characteristics.
