The following table presents an overview of the different types of activity that can be traced using Isah Monitor.
Trace Category |
Displays |
Prepared Query Statements |
Prepared statements to be sent to the server. |
Executed Query Statements |
Statements to be executed by the server. Note that a single statement may be prepared once and executed several times with different parameter bindings. |
Input Parameters |
Parameter data sent to servers when running stored procedures according to these parameters. |
Fetched Data |
Data retrieved from servers. |
Statement Operations |
Each operation performed such as ALLOCATE, PREPARE, EXECUTE, and FETCH |
Connect / Disconnect |
Operations associated with connecting and disconnecting to databases, including allocation of connection handles, freeing connection handles, if required by server. |
Transactions |
Transaction operations such as BEGIN, COMMIT, and ROLLBACK (ABORT). |
Blob I/O |
Operations on Blob data types, including GET BLOB HANDLE, TORE BLOB, and so on. |
Miscellaneous |
Operations not covered by other categories. |
Vendor Errors |
Error messages returned by the server. The error message may include an error code, depending on the server. |
Vendor Calls |
Actual API function calls to the server. |
By viewing the results of the Executed Query Statements, you can retrieve information about the time that is taken to carry out an activity. You can then compare it to the time that is taken to complete the data transport involved. This provides additional information about your network capacity.
Note: It is recommended that you only enable the Fetched Data option when it is actually required.