SQLData object diagnostic status
- Last UpdatedJul 19, 2024
- 1 minute read
The SQLData object provides status indicating the number of times the database has been accessed, the SQL session connection time, and the time taken to complete a database access command initiated by the object.
When the object initiates a data transfer to the database, a database write counter (DBWriteCnt Integer attribute) is incremented.
When the object fails to transfer data to the database, a database write failed counter (DBWriteFailedCnt Integer attribute) is incremented.
When the object initiates a data transfer from the database to attributes, a database read counter (DBReadCnt Integer attribute) is incremented.
When the object fails to transfer data from the database, a database read failed counter (DBReadFailedCnt Integer attribute) is incremented.
When the object initiates a database access command, the execution time taken for the command is written to the LastCmdExecutionDuration attribute.
The object monitors the connection time with the SQL Server database, and the connection time is written to the DBConnectionUpTime attribute.
The object provides a command (DiagnosticsResetCmd attribute) to reset all diagnostic status attributes.