RemoteServerActivity Data Collector

"RemoteServerActivity" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Server Activity (s).

To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_serverioact     (temptable name)
bytes-qry bytSndQry num Number of bytes sent in response to a query
bytes-recv MB Rcvd num Megabytes received
bytes-sent MB Sent num Megabytes sent
curr-usr Cnx num Number of connections (not users) to the database
hr   num Buffer hit rate
loginport -S num Name of the service used by the broker process
max-usr Max num Maximum number of servers broker can spawn. -Mpb startup parameter for the database server
msg-recv MsgRcvd num Number of messages received by the server
msg-sent MsgSent num Number of messages sent
qry-recv QryRcvd num Number of queries received by the server
rec-recv RecRcvd num Number of records received
rec-sent RecSent num Number of records sent
recs-qry recSndQry num Number of records sent in response to a query
rmsg-sz RcvdSz num Average size of received network messages
rrec-msg rr/msg num Records received per network message
smsg-sz SendSz num Average size of sent network messages (this should approach the value of -Mm, the message buffer size)
srec-msg rs/msg num Records sent per network message
srvnum Srv num Server number
srvport Port num Port number of the database server host; if using OpenEdge Management or OpenEdge Explorer, the port number of the NameServer
srvtyp Type char SQL, ABL or BOTH. Type of service supplied by server
srv-dba   num Logical Reads
srv-dbr   num OS Reads
srv-dbw   num OS Writes
tm-intr   num Time interval/slice