Identifying Resource-Intensive Processes

Find the user processes that are consuming the most system resources on the selected SAP ASE.

You can choose a system resource (CPU, disk I/O, incoming network traffic, or outgoing network traffic) and display information about the user processes that are using the chosen resource most intensively. For each system resource, you can rank the processes by cumulative or most recent activity values. Each bar in the graph represents the value of the selected metric for a process.

In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
In the left pane, select Processes.
By default, the All Processes tab is selected. A bar graph shows the five user processes that are using the most cumulative CPU cycles.
(Optional for cluster configurations) Click Select User Processes by. Choose All Instances to depict information for the entire cluster, or select a specific instance to see information for only the selected instance of the cluster.
Use the menu to the right of the bar graph to change the system resource. You can choose:
- CPU Cumulative – cumulative CPU activity since the server started or the counter wrapped.
- CPU Activity – CPU activity, per second, since the last screen refresh.
- Disk I/O Cumulative – cumulative disk I/O since the server started or the counter wrapped.
- Disk I/O Activity – I/O activity per second since the last screen refresh.
- Incoming Network Traffic Cumulative – cumulative incoming network traffic since the server started or the counter wrapped.
- Incoming Network Traffic Activity – incoming network traffic per second since the last screen refresh.
- Outgoing Network Traffic Cumulative – cumulative outgoing network traffic since the server started or the counter wrapped.
- Outgoing Network Traffic Activity – outgoing network traffic per second since the last screen refresh.
(Optional) Move your mouse over a bar in the graph to display the server process ID (SPID) and the value of the selected system resource metric for the process.
(Optional) Select Only display user processes below to filter out system processes, and display only user process information.
(Optional) Click a bar in the graph to highlight information about that process in the table below.
(Optional) Click a bar in the graph or a row in the table to display information about that process in the Details, SQL, and Wait Events tabs at the bottom of the screen.