Help for Foxhound 3.0.4386a

Table of Contents     [RisingRoad]

The Change Target Settings page appears in a popup window to let you change various settings on the target database to be more or less favorable to the recording of data for Foxhound to display on the Monitor, History and Connection History pages.

Favorable Current Setting?

The Favorable Current Setting? colunn is refreshed when the Change Target Settings page is displayed and whenever one of the Yes / No buttons is pressed:

• Yes means the setting is favorable to Foxhound,
• No means the setting is not favorable, and
• [not available] means sampling is stopped, the target database is not available, or the SQL Anywhere version used to run the target database does not support the setting.

Yes / No Buttons

The and buttons let you immediately change the corresponding setting, but they're disabled if the setting is not available.

RememberLastPlan -zp:

The RememberLastPlan server option controls whether or not anything is displayed in the connection-level "Last Plan Text" field on the Monitor, History and Connection History pages.

Changes to RememberLastPlan affect both new and existing connections.

You can also enable RememberLastPlan server option as follows:

• Specify the -zp server command line option when starting the target database.

  - or -

• CALL sa_server_option ( 'RememberLastPlan', 'YES' ) on the target database.

RememberLastStatement -zl:

The RememberLastStatement server option controls whether or not anything is displayed in the connection-level "Blocked Statement" and "Last Statement" fields on the Monitor, History and Connection History pages.

You can also enable RememberLastStatement server option as follows:

• Specify the -zl server command line option when starting the target database.

  - or -

• Call sa_server_option() on the target database:

  CALL sa_server_option ( 'Remember_last_statement', 'ON'  );  -- Version 8
  CALL sa_server_option ( 'RememberLastStatement',   'ON'  );  -- Version 9
  CALL sa_server_option ( 'RememberLastStatement',   'YES' );  -- Versions 10, 11, 12, 16

If that doesn't work, try turning off client statement caching on the target database:

SET TEMPORARY OPTION MAX_CLIENT_STATEMENTS_CACHED = '0'; 

- or -

SET OPTION PUBLIC.MAX_CLIENT_STATEMENTS_CACHED = '0';

Changes to RememberLastStatement affect both new and existing connections.

RequestTiming -zt:

The RequestTiming server option controls whether or not anything is displayed in the following connection-level fields on the Monitor, History and Connection History pages:

• Req
• Busy
• Waiting
• Waiting Time

You can also enable RequestTiming server option as follows:

• Specify the -zt server command line option when starting the target database.

  - or -

• CALL sa_server_option ( 'RequestTiming', 'YES' ) on the target database.

The RequestTiming setting controls the following SQL Anywhere statistical properties that Foxhound uses in calculations:

• ReqTimeActive

• ReqTimeBlockContention

• ReqTimeBlockIO

• ReqTimeBlockLock

• ReqTimeUnscheduled

Changes to RequestTiming affect new connections, and they may or may not immediately affect existing connections as follows:

• Changing RequestTiming from No to Yes will not immediately affect existing connections.

• Changing RequestTiming from Yes to No may or may not immediately affect existing connections, depending on the version of SQL Anywhere used for the target database.

Close Button

The button can be used to close the Change Target Settings page.