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

The database server can store the values of numeric database server properties so that you can track the changes of numeric database server properties over time.

Tracking database server property values over time aids in evaluating the overall health of a database server. For example, a brief increase in CPU usage may not be an issue, but if the CPU usage is at 100 percent for an extended period of time, it could indicate that the hardware is insufficient.

Rather than having to poll, analyze, and store database server property values at regular intervals, configure the database server to track database server properties that return numeric values. These values are stored in memory for a period of time so that polling can be done at larger intervals, reducing the load on the database server.

When database server property tracking is enabled, property values are tracked at fixed intervals and you can query historic property values by using the sp_property_history system procedure.