Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Server activity (_ActServer)
 
Server activity (_ActServer)
The _ActServer VST displays server activity information, including the number of bytes sent and received, the number of messages sent and received, the number of queries received, the number of records sent and received, the number of query time slice switches, the number of transactions committed, and database up time.1
Field name
Data type
Description
_Server-ByteRec
INT64
Number of bytes received by the server
_Server-Id
INT64
Server ID
_Server-ByteSent
INT64
Number of bytes sent by the server
_Server-MsgRec
INT64
Number of network packets received by the server
_Server-MsgSent
INT64
Number of network packets sent by the server
_Server-QryRec
INT64
Number of query requests received
_Server-RecRec
INT64
Number of records received
_Server-RecSent
INT64
Number of records sent
_Server-TimeSlice
INT64
Number of query time slice switches
_Server-Trans
INT64
Number of transactions committed
_Server-UpTime
INTEGER
Number of seconds the database was up

1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.