The Chart Setting tab on the Preferences window for the Performance Monitor is for controlling the display of the charts.
The following settings affect the chart display of the selected statistic when you have drilled down to the bottom level of information.
Specify the width of the line for the statistic that you have selected in the left pane. This is used to enable the statistic selected in the left pane to stand out from the other statistics in the chart.
Select the color for the selected statistic from the drop-down list.
Select the color for the chart background from the drop-down list.
Select the format for displaying the date and time on the chart from the drop-down list.
The Information tab on the Preferences window for the Performance Monitor determines which of the top SQL statements are highlighted, sets highlighting colors, and sets the automatic display of the connection information when logging on.
In the left pane of the Performance Monitor window, individual SQL statements are displayed when you drill down from Information to Process Information to the Executing SQL Statements. The following settings determine how many SQL statements are highlighted, by what criteria they are sorted, and the color that is used for highlighting.
The top SQL statements are highlighted for you to quickly identify which SQL statements are consuming the most resources.
Specify the number of SQL statements to be highlighted.
Order By (Default = CPU Time(ms))
Select the statistic to sort the SQL statements from the drop-down field.
Highlight Color (Default = Yellow)
Select the color from the drop-down field.
When you drill down to the lowest level of the charts, the data from the table displays in a grid underneath the chart. The column for the statistic that is selected in the left pane is highlighted.
Select the color from the drop-down field.
Specify to exclude the SQL statements that are generated by any of the modules in SQL Optimizer but the Performance Monitor.
Specify to exclude the SQL statements that are generated by the Performance Monitor.
Specify to display the Connection Information window each time you logon if the user logon does not have the database privileges needed for the modules.
The Top-N Display tab on the Preferences window for the Performance Monitor is for determining the percent of each statistics that is retrieved from the monitoring tables.
To select only the top statistics
Select the button on the left for the statistics information and fill in the values on the right for each individual statistic.
Please reference the Adaptive Server Performance and Tuning: Monitor and Analyzing manual for the meaning of each statistic.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center