Monitoring PSQL Servers with DTO : DtoCommStat Object
 
DtoCommStat Object
An object that represents usage information for a server.
Properties
CurActiveThreads
Returns the current number of active threads for a session.
CurQueuedRequests
Returns the number of queued requests for a session.
CurRemoteSessions
Returns the number of queued requests for a session or protocol.
MaxActiveThreads
Returns the maximum number of active threads for a session.
MaxQueuedRequests
Returns the maximum number of queued requests for a session.
MaxRemoteSessions
Returns the maximum number of remote sessions for a session.
PeakActiveThreads
Returns the highest number of active threads for a session
PeakQueuedRequests
Returns the highest number of queued requests for a session.
PeakRemoteSessions
Returns the highest number of remote sessions for a session
RequestsProcessed
Returns the total number of requests processed for a session
TotalTimeOuts
DTO2 only: Returns the total number of communication time outs.
TotalRecoveries
DTO2 only: Returns the total number of reconnects using the PSQL Auto Reconnect feature. See Advanced Operations Guide for more information on PSQL Auto Reconnect.
Collections
DtoProtocolStats Collection
Objects
DtoMonitor Object
Methods
None
Remarks
All the properties for this object return values of type Long integer.
Example
’ Instantiate session and connect
Dim my_session as new DtoSession
Dim result as DtoResult
result = my_session.Connect("myserver", "username", "password")
 
’ Get monitor object from session
Dim my_monitor as DtoMonitor
Set my_monitor = my_session.Monitor
 
’ Get comm stat object
Dim my_commstat as DtoCommStat
Set my_commstat = my_monitor.MkdeCommStat
 
’ Get total number of requests processed
Dim requests as long
requests = my_commstat.RequestsProcessed
See Also
DtoMonitor Object
DtoProtocolStats Collection
DtoProtocolStat Object