SQL Monitor

From RAD Studio
Jump to: navigation, search

Go Up to Database Dialog Boxes

Database > SQL 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 Options > Trace Options to display the Trace Options dialog box.

Trace Options - Category Page

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.



Trace Options - Buffer Page

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.