Monitoring PSQL Servers with DTO : DtoMonitor Object
 
DtoMonitor Object
This object provides usage information about a PSQL server. It is the root object of all other monitoring operations.
Properties
CurClients
Returns the current number of clients for a session.
CurFilesInUse
Returns the current number of files in use for a session.
CurHandlesInUse
Returns the current number of handles in use for a session.
CurLicensesInUse
Returns the current number of licenses in use for a session.
CurLicDataInUseMB
Returns the current value in megabytes (MB) of data in use. DTO2 only.
CurLocksInUse
Returns the current number of locks in use for a session.
CurSessionCountInUse
Returns the current number of sessions in use (the current session count). DTO2 only.
CurThreads
Returns the number of threads for a session.
CurTransInUse
Returns the current number of open transactions for a session.
EngineUpTimeSecs
Returns how long in seconds the database engine has been running. DTO2 only.
MaxClients
Returns the maximum number of clients for a session.
MaxFiles
Returns the maximum number of files for a session.
MaxHandles
Returns the maximum number of handles for a session.
MaxLicenses
Returns the user license count for a session.
MaxLicDataMB
Returns the maximum allowed size in megabytes (MB) for data in use (the data in use limit). The hex value 0xFFFFFFFF means unlimited. DTO2 only.
MaxSessionCount
Returns the maximum number of sessions allowed by a license (the session count limit). The hex value 0xFFFFFFFF means unlimited. DTO2 only.
MaxThreads
Returns the maximum number of threads for a session.
MaxTrans
Returns the maximum number of transactions for a session.
PeakClients
Returns the highest number of clients for a session
PeakFilesInUse
Returns the highest number of files in use for a session
PeakHandlesInUse
Returns the highest number of handles in use for a session
PeakLicensesInUse
Returns the highest number of licenses in use for a session
PeakLicDataInUseMB
Returns the peak value in megabytes (MB) of concurrent data in use. DTO2 only.
PeakLocksInUse
Returns the highest number of locks in use for a session
PeakSessionCountInUse
Returns the peak number of concurrent sessions in use. DTO2 only.
PeakThreads
Returns the highest number of threads for a session.
PeakTransInUse
Returns the highest number of transactions in use for a session.
Collections
DtoMkdeClients Collection
DtoOpenFiles Collection
DtoSqlClients Collection
Objects
DtoCommStat Object
DtoSession Object
DtoMkdeVersion Object
Methods
None
Example
’ Instantiate session and connect to server
Dim my_session as new DtoSession
Dim result as DtoResult
result = my_session.Connect("myserver", "username", "password")
 
’ Now get DtoMonitor object from DtoSession
Dim session_monitor as DtoMonitor
Set session_monitor = my_session.Monitor
 
’ Now get current files in use
Dim current_files as long
current_files = session_monitor.CurFilesInUse
See Also
DtoOpenFiles Collection
DtoMkdeClients Collection
DtoMonitor Object