Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties » Database server property tracking

Configuring database server property tracking

Configure your database server to track the values of numeric database server properties.

Context

Only database server properties with numeric values can be tracked.

Procedure

Choose one or both of the following options:
Option Action
Specify database server properties to be tracked for the database server
  • When starting the database server, use the -phl and -phs database server options to turn on history tracking for a list of specified database server properties and to specify the maximum amount of memory to use for tracking property history. For example, run the following command:

    dbsrv17 -n myserver -phl ProcessCPUSystem, ProcessCPUUser -phs 250K
  • If the database server is already running, then use the sa_server_option system procedure to configure property tracking for the database server. For example, execute the following statement:

    CALL sa_server_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser,PropertyHistorySize,250K' );
Specify database server properties to be tracked for the database

Use the sa_db_option system procedure to configure property tracking of database server properties for the database. For example, execute the following statement:

CALL sa_db_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser' );

Results

The values of the specified database server properties are tracked for either the specified amount of time or until the specified maximum amount of memory has been reached.