Thread Statistics and Details

Interpret Adaptive Server thread information.

In a cluster environment, threads created on instances of a cluster are displayed as an Instance Thread in the right hand pane of the Threads screen.

Tabs
Details
Displays information about affinity and number of ticks in the selected thread, including:
  • Total number of ticks
  • Number of idle ticks
  • Number of sleeping ticks
  • Number of busy ticks
Also displays page faults and operating system context switches with the current thread, including:
  • Number of minor and major page faults
  • Operating system thread ID and alternative thread ID
  • Number of voluntary and forced context switches
Thread CPU Utilization
Displays graphs depicting user and system CPU utilization.
Note: A data collection job must be scheduled to display the graphs.
Tasks

Displays a list of all the kernel task names and IDs associated with thread pools.

Related tasks
Creating a Thread Pool
Creating Execution Classes
Creating Engine Groups
Related reference
Thread Pool Properties
Execution Classes Properties
Engine Groups Properties