SQL Monitor

DatabaseSQL Monitor

Use this dialog box to see the actual statement calls made through SQL Links to a remote server or through the ODBC socket to an ODBC data source.

You can monitor different types of activity by choosing OptionsTrace Options to display the Trace Options dialog box.

Use this page to select the trace categories to be monitored.

Item	Description
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 doing INSERTs or UPDATEs.
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 datatypes, including GET BLOB HANDLE, STORE 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. For example, ORLON for Oracle, ISC_ATTACH for InterBase.

Use this page to manage the trace buffer maintained in memory by the SQL Monitor.

Item	Description
Buffer Size	Indicates the size of the buffer to be used for trace information.
Circular	Writes trace information in a circular memory buffer, so that once the limit is reached, additional traces replace the first traces.
Page to disk	Writes trace information to a disk file when the memory buffer becomes full.
Filename	Indicates the name of the trace file to be used if Page to disk is selected.

What do you think about this topic? Send feedback!