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.
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. |
