Displaying the Performance Overview

The Overview screen shows Adaptive Server performance status.

1. In the Perspective Resources view, select the server, click the drop-down arrow, and select Monitor. Alternately, in the Administration Console, select the server, click the drop-down arrow, and select Monitor.
   The Adaptive Server monitor opens and displays the Overview screen. Check the server information in the upper left corner of the screen for the server’s name, software product and version, its hardware platform, and an indication of whether the server is running. For cluster configurations, you also see the status of instances of each cluster, and the number of blocked process.

   Note: When Sybase Control Center shows a server status of “Stopped,” it means that the server is unreachable over the network.
2. (Optional) If data collections are running, mouse over the Engine CPU Utilization graph to display precise figures (values, times, and dates) for points on the curve.
   The graph shows the aggregate CPU utilization for all engines on the server. For cluster configurations, the graph shows the aggregate CPU utilization for each instance of the cluster.
3. (Optional – not in Adaptive Server cluster configurations) Move your mouse over the Device IO/Sec graph to display precise figures (values, times, and dates) for points on the curve.
   The graph shows device I/O aggregated across all devices on the server.
4. (Optional – not in Adaptive Server cluster configurations) Look at the Processes chart (far right) to see the number of configured and currently running processes and the highest number of concurrent processes since the server started, as well as the number of blocked processes.
5. (Optional – not in Adaptive Server cluster configurations) Look at the Memory chart to see statistics on caches and on physical, logical, and unused memory.
6. (Optional) Click a tab to see information about the resource you want to monitor:
   • Details - displays the version, edition, platform, number of deadlocks, platform, page size, device size and counters cleared for the Adaptive Server.
   • Configured Resources - displays, in tabular form, the configurable resources for each server or cluster instance. Each configuration option is displayed along with its currently configured value, run value that is currently used by the server, percentage of the resource that is currently in use, and the high water mark, which is the maximum amount of resource that has been used since the server was booted. Any column can be used to sort the table.
     The configured value for a resource is an editable field, denoted as such by a "pencil" Edit icon. Input a new numerical value for one or more resources, then choose either:

     • Save All to update the server with the new values. Sybase Control Center displays the new values. If the Adaptive Server encounters an error while applying the new value for a resource, Sybase Control Center displays the error below the table, and also next to the changed field in the row that causes the server error.
     • Reset All to restore the original value for the resource.
     Note: Resources for each server or cluster instance may also be configured on the Server Configurations window.
   • Wait Events - displays a list of server-wide wait events that can be very useful in performance tuning. Information about the wait-events includes the number of waits, wait time, average wait time, and wait description. For clustered servers, this information is displayed per instance.
   • Licenses - displays a list of licenses that are currently checked out by the server or cluster instances. There is also information about the number, type, status (expirable, permanent and so on), and expiration date of each license.
   • Alerts - displays a list of all fired alerts configured at server, cluster or cluster instance levels. For each alert, there is information about the time at which the alert was fired, severity, current statistic and threshold.
7. (Optional - Adaptive Server Cluster configurations) Mouse over the Cluster Instances graph to display precise information for points on the bar graph.
8. (Optional - Adaptive Server Cluster configurations) If data collections are running, mouse over the Logical Cluster graph to display precise information for points on the bar graph.

• Performance Overview Statistics and Details
  Learn about the information presented on the Overview screen.