Displaying the Performance Overview

The Overview screen shows performance status.

Check the Overview window to find out whether the server is running, and details about memory usage, CPU utilization, recent alerts, and so on. Other windows in the SAP Adaptive Server Enterprise monitor display more detailed information about the status of individual server resources, such as engines, databases, caches, and processes. In cluster configurations, the Clusters Overview window allows you to check whether a particular cluster is running, how many instances of the cluster are down, and so on.

  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 SAP Adaptive Server Enterprise 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 a server status is Stopped, it means that the server is unreachable over the network.
  2. (Optional) If data collections are running, move the 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 available in 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 available in 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 available in cluster configurations) Look at the Memory chart to see statistics for caches and for 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 server.
    • Configured Resources – displays, in tabular form, the configurable resources for each server or cluster instance. Each configuration option is shown along with its currently configured value, the run value that is currently used by the server, the percentage of the resource that is currently in use, and the high-water mark, which is the maximum amount of resources used since the server started. You can sort the table on any column.
      The configured value for a resource is an editable field, denoted as such by a "pencil" Edit icon. Enter a new numerical value for one or more resources, then choose either:
      • Save All to update the server with the new values. SCC displays the new values. If the server encounters an error while applying the new value for a resource, SCC 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: You can also configure resources for each server or cluster instance in the Server Configurations window.
    • Wait Events – displays a list of server-wide wait events that can be very useful in performance tuning. Wait-event information includes the number of waits, wait time, average wait time, and wait description. For clustered servers, this information is shown for each instance.
    • Licenses – displays a list of licenses that are currently checked out by the server, or by cluster instances. There is also information about the number, type, status (expirable, permanent and so on), and the expiration date of each license.
    • Alerts – displays a list of all fired alerts configured at server, cluster or cluster instance levels. The information for each alert includes the time at which the alert was fired, severity, current statistic, and threshold.
  7. (Optional; for cluster configurations) Move your mouse over the Cluster Instances graph to display precise information for points on the bar graph.
  8. (Optional; for cluster configurations) If data collections are running, mouse over the Logical Cluster graph to display precise information for points on the bar graph.
Related concepts
Displaying the Cluster Overview
Interpreting Statistics