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