Global variables for monitoring system activity

Many global variables report on system activity occurring from the last time Adaptive Server was started. sp_monitor displays the current values of some of the global variables.

Table 15-9 lists the global variables that monitor system activity, in the order returned by sp_monitor. See the Reference Manual: Procedures.

Table 15-9: Global variables that monitor system activity

Global variable

Description

@@authmech

A read-only global variable, set to the mechanism used to authenticate the user.

@@connections

Contains the number of logins or attempted logins.

@@cpu_busy

Contains the amount of time, in ticks, that the CPU has spent doing Adaptive Server work since the last time Adaptive Server was started.

@@idle

Contains the amount of time, in ticks, that Adaptive Server has been idle since it was last started.

@@io_busy

Contains the amount of time, in ticks, that Adaptive Server has spent doing input and output operations.

@@packet_errors

Contains the number of errors that occurred while Adaptive Server was sending and receiving packets.

@@monitors_active

Reduces the number of messages displayed by sp_sysmon.

@@pack_received

Contains the number of input packets read by Adaptive Server since it was last started.

@@pack_sent

Contains the number of output packets written by Adaptive Server since it was last started.

@@total_errors

Contains the number of errors that occurred while Adaptive Server was reading or writing.

@@total_read

Contains the number of disk reads by Adaptive Server since it was last started.

@@total_write

Contains the number of disk writes by Adaptive Server since it was last started.