Performance Overview Statistics and Details

Learn about the information presented on the Overview screen.

The Overview screen displays high-level information about this Adaptive Server. The tables and charts are populated by data from the collection_ase_all_client_kpis, covering the current chart trend period.

Note: The Overview screen is called Cluster Overview in Adaptive Server cluster configurations.

Engine CPU Utilization	Displays aggregate CPU utilization for all engines on this server. For information on individual Adaptive Server engines, see the Engines screen. (Because all I/O for a process goes through one engine, CPU usage is not always evenly distributed across engines.) For cluster configurations, the graph shows the aggregate CPU utilization for each instance of the cluster.
Device IO/Sec	(For Adaptive Server cluster configurations, this information is on the Cluster Instances window) Displays device I/O per second aggregated across all devices on this server. For information on individual devices, see the Devices screen.
Memory	(For Adaptive Server cluster configurations, this information is on the Cluster Instances window) Displays memory usage statistics, including: The amounts of physical and logical memory in use The amount of unused memory The size of the procedure, statement, and data caches
Processes	Displays process statistics, including: Max User Processes – number of processes this server is configured for High Water Mark – highest number of processes that ran concurrently since this server started Active – processes running now (Adaptive Server cluster configurations only) Blocked Processes – processes that are waiting for a resource or for another process to finish For more on processes, see the Processes screen.
Details tab	Displays information about this server, including number of days it has been running, number of deadlocks, data cache hit rate, procedure cache stalls, page and device sizes, maximum number of online engines, number of open databases, and the dates and times of the server’s most recent restart and of the clearing of these counters. For cluster configurations, the Details tab also displays information about software product and version, hardware platform, server edition , number of dead locks, page and device sizes, and when the server was last re-started, and the counters last cleared.
Configured Resources tab	Displays usage statistics for many of the configured resources for this server or cluster instance: Current – amount of this resource the server is using now Run value – configured maximum for this resource Percentage – percentage of the configured maximum represented by the current use of this resource High Water Mark – maximum amount of this resource that has been used since this server started Use the Percentage and High Water Mark columns to identify resources that might be over-configured or under-configured. For information on configured resources, see the Adaptive Server Enterprise documentation.
Wait Events	Displays a list ofserver-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 tab	Displays information about software licenses for Adaptive Server Enterprise on this server or cluster instance.
Alerts tab	Displays, for this server, cluster, or cluster instance, all alert notifications that have occurred since the Adaptive Server monitor was opened. If any alerts have occurred since you last looked at the Alerts tab, a yellow warning icon appears on the tab. You can control the number of alerts displayed using the Alert List Size property on the Settings screen.