Sybase 12.5.1, User Manual

Page: 120 / 210

Table of data items and definitions
106
Historical Server
Cache Spinlock
Contention
Version: 11.0 and later
The fraction of the requests for a data cache’s spinlock that were forced to wait.
spinlock_waits / spinlock_requests
Type: Result
Code Memory Size
Version: 11.0 and later
Amount of memory in bytes allocated to Adaptive Server.
Type: Result
Connect Time
Version: 11.0 and later
Number of seconds elapsed since the process was started or since the session was
started, whichever is smaller.
Type: Result
CPU Busy Percent
Version: 11.0 and later
Percentage of total server CPU ticks that the Adaptive Server CPU was busy.
Type: Result
CPU Percent
Version: 11.0 and later
If used in a view with Process ID, this is the percentage of time a single process was in
the Running state over the time all processes were in the Running state.
If used in a view with Application Name, this is the percentage of time the set of
processes running a given application were in the Running state over the time all
processes were in the Running state.
Type: Result
CPU Time
Version: 11.0 and later
If used in a view with no keys, this data item is the total CPU busy time, in seconds,
on the server. If used with keys, this data item is the busy time, in seconds, that was
used by each process, application, or engine. Process ID and Application Name are
mutually exclusive.
Type: Result
CPU Yields
Version: 11.0 or later
Number of times that the Adaptive Server yielded to the operating system.
Type: Result
Current Application
Name
Version: 11.0 and later
The name of the application that is currently executing on a particular process.
Type: Result
Current Engine
Version: 11.0 and later
Number of the Adaptive Server engine on which the process was running most
recently.
Type: Result
Current Execution Class
Version: 11.5 and later
The name of the execution class under which a process is currently running.
Type: Result
Current Process State
Version: 11.0 and later
Current state of a process. See Process State for definitions of the possible states.
Type: Result
Data item Description