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 14-8 lists the global variables that monitor system activity, in the order returned by sp_monitor. For complete information on sp_monitor, see the Reference Manual.
Global variable |
Description |
|---|---|
@@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. |
@@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. |
