Displays the processing thread manager counts. Values are server-wide (i.e., it does not matter whether you select this option for main or private). They represent new events after the last page of the report.
monitor_options -threads
Output field |
Description |
|---|---|
cpus |
Number of CPUs Sybase IQ is using; this may be less than the number on the system |
Limit |
Maximum number of threads Sybase IQ can use |
NTeams |
Number of thread teams currently in use |
MaxTms |
Largest number of teams that has ever been in use |
NThrds |
Current number of existing threads |
Resrvd |
Number of threads reserved for system (connection) use |
Free |
Number of threads available for assignment. Monitor this value if it is very low, it indicates thread starvation |
Locks |
Number of locks taken on the thread manager |
Waits |
Number of times Sybase IQ had to wait for the lock on the thread manager |