Task Manager

Use

In the Kernel Threads user menu, you can find, among other things, a display of all tasks and their current status. You can end running SQL statements and tasks.

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose Start of the navigation path Current Status Next navigation step Kernel Threads Task Manager End of the navigation path .

or

Open the DBA Cockpit (transaction DBACOCKPIT) and select Start of the navigation path Performance Next navigation step Kernel Threads Task Manager End of the navigation path .

Result

The system displays an overview of the database tasks and information about the current state of each individual task. The following views are available:

Active Tasks
Executable Tasks
User Tasks (User task type)
System Tasks
All Tasks

You obtain the following data, among other things:

ID	Internal Task ID
Thread ID	Thread ID of the corresponding internal task
Application PID	Process ID of the application program linked to the task A * before the PID indicates that the PID is on a separate server.
Task State	Information about the current state of the database task.
LCApps	liveCache Technology: Name of the DB Procedure

Refreshing the Display

You can refresh the display. To do so, choose Start of the navigation path Edit Next navigation step Refresh End of the navigation path .

You can automate this function by choosing Start of the navigation path Edit Next navigation step Automatic Refresh On/Off End of the navigation path . The display for the function for the automatic refresh is above the header line of the table (green symbol: on, red symbol: off). In the field next to this, you can specify the time interval with which the automatic refresh should take place. The default value is 5 seconds.

Displaying Task Details

In the Task Manager, you can display detailed information about a task.

Select a task.
Choose Edit Task Details .

Analyze the display of the task details.

liveCache Technology: The system displays the current name of the running DB procedure here, among other things.

Activating/Deactivating DB Time Measurement

In the Task Manager, you can activate or deactivate the internal time measurement for database activities.

You can use this function to, for example, calculate the average response times for an SQL command.

Choose Edit Activate DB Time Measurement .
Perform the desired time measurements.
Choose Edit Deactivate DB Time Measurement .

Evaluation of measurement data can be done via the analysis of bottlenecks using the Database Analyzer.

Terminating an SQL Command/SQL Session

You can terminate an SQL statement (command) or an SQL session in the Task Manager.

Select a task.
Choose Edit Terminate SQL Command . This terminates the SQL command currently being processed.

or

Choose Edit Terminate SQL Session . This terminates the task. If a work process of the SAP system was connected with the terminated task, the work process immediately logs on to a new task.

If you want the affected SQL command to still be recorded in the performance trace after the termination, use one of these options to terminate a running action. If you terminate an action by terminating the corresponding work process (transaction code SM50), the SQL command is not recorded in the trace.

Example

Task	State	Possible Causes	Possible Reactions
Log Writer	I/O wait	I/O bottleneck in the log area	Monitoring the Log Area
User	I/O wait	Data cache too small Low performance of disk I/O	Monitoring Caches Monitoring I/O Operations Further analysis of Bottlenecks
User	Vwait	SQL statements in the application cause SQL locks	Analyzing Wait Situations.

Task

State

Possible Causes

Possible Reactions

Log Writer

I/O wait

I/O bottleneck in the log area

Monitoring the Log Area

User

I/O wait

Data cache too small

Low performance of disk I/O