15 Performance Diagnostics
Use the Last drop-down list
box to select the duration for which you want to see the chart. Select the 1 hour, 4 hours, 12 hours, or 24 hours. You can also select the date and time through which you want the data to be displayed (see Figure 15.3).
The first chart displays the number of wait events that have occurred over the period of time that is selected for the charts.
You can narrow down the timeline
in the first chart to analyze the data for a specific period (see Figure 15.4). The second chart displays the total number of wait events of each type, for the timeline that you select in the first chart. You can select the specific wait event types for which you want to analyze the data.
•
|
The SQL tab displays the list of SQL queries having wait events for the selected sample time (see Figure 15.5).
|
•
|
The Users tab displays the details of the wait events grouped by users for selected sample time.
|
•
|
The Waits tab displays the number of wait events belonging to each wait event type for the selected sample time.
|
Click on the Eye icon in any row to display a new
tab with details of the query for a particular row. This
tab displays the Query ID and its corresponding sessions IDs in a dropdown list. Select the session ID for the query for which you want to analyze the data; the tab will display details corresponding to the selected session ID and query ID.
The Waits information table displays the SQL query (see Figure 15.6). If the SQL query is being displayed partially, click the down arrow at the bottom of the section to view the complete SQL query.
The Wait Types panel (see Figure 15.7) displays the total number of wait events for the selected session ID and query ID. Select a time range
in the first chart to analyze the data for a specific period.
The Wait Types bar graph displays the total number of wait event types for the duration that you select. To make differentiation easier, each wait event type is represented by a different color in the bar graph.
In the Wait Events donut chart (see Figure 15.8), all the wait event types applicable to the selected timeline are displayed a percentage format. You can select any one wait event type to see all the wait events belonging to that particular wait event type and their count. Click the Read More link to read about the various wait event types and wait events.
15 Performance Diagnostics