The center of the Monitor page gives a visual representation of the state of your servers.
The graphs present information about the currently selected server or server group. The default graphs show the hit ratios, CPU utilization, connections, and database activity for a specific interval.
Graphs also let you drill down from overall usage information to the queries that were being executed on the server at the time. Click and drag on a graph to zoom in on the graph content and view the queries that were being executed during the specified period, to understand server performance and responsiveness. This information is only available when you configure query analysis, and enable query analysis for the servers you are monitoring. For more information, see Section 2.6, “The Query Analyzer Tab”.
To set the interval, click the configure
graphs link immediately below the graphs. In the
resulting dialog box, choose the default interval for the x-axis
of the graphs. Defining a shorter or longer interval gives you a
shorter or longer term view of server activity. You can also
adjust the thumbnail and full-size graph dimensions from this
dialog box. Save any changes, and the chosen values become the
defaults whenever you log in.
You can also choose the default graphs shown on the
Monitor page. Click the edit
favorites link and choose the graphs you want from the
drop-down list box. To choose contiguous graphs, hold down the
Shift key and click the desired graphs. To
select graphs that are not in a sequence, click the desired
graphs while holding down the Ctrl key. The
Monitor page can display a maximum of six
graphs. Save your changes, and these become be the default
graphs whenever you log in.
Color coding helps distinguish different aspects of each graph.
With Database Activity for example, you can
readily distinguish SELECT statements from
INSERT statements.
Clicking a graph opens a detailed view with Graph Display and Configure tabs. Choose the Configure tab to temporarily change the way that a graph displays. Changes made from this tab only apply to the standalone graph while it is open. Persistent changes are made as described above.
Dismiss the enlarged graph by clicking the button.
Alerts from the event system are displayed immediately below the charts. For more information on the events display, see Section 2.4, “The Events Tab”.
To export a graph, either a .png file of the
graph image or a .csv file of the underlying
data, use the two icons to the right of the graph label. See
Section 2.5.4, “Exporting Graph Images and Data” for details about the
export feature.
