Databases Reference
In-Depth Information
The Interesting Events report, shown in Figure 12-16, identii es different events that occurred
during the data collection that might provide some insight into your troubleshooting efforts. The
report groups the events by type and then by runtime intervals, displaying a grouping of all
the interesting events that were captured during the specii ed time interval that you are analyzing.
Examples include query cancellations (Attentions), sort warnings, hash warnings and exceptions.
The Parameters tab provides you with the functionality of narrowing down the time window that
you are interested in.
FIGURE 12-16
When you look into the reports showing information about the unique batches
or unique statements, you can drill through by clicking on the batch or the
query. This gives you a view of the CPU usage, duration, reads, and writes
recorded for each execution within the time interval. You can also view the
query plan and the query text for the batch or statement using the drill-through
options.
All the reports discussed so far include the functionality to be exported in the
formats shown in Figure 12-17 using the Export option available in the SQL
Nexus UI.
FIGURE 12-17
Search WWH ::
Custom Search