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