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 » Performance improvements, diagnostics, and monitoring » Performance » Tips for improving performance

Tip: Use resource governors

Resource governors can be used to improve performance.

Resource governors are a set of database options you can use to control resources. These options can be set using the SET OPTION statement.

Building a set of users and roles allows you to manage privileges on a database. Another aspect of database security and management is to limit the resources an individual user can use.

For example, you can prevent a single connection from taking too much of the available memory or CPU resources, so you can avoid having a connection slow down other users of the database.

Resources that can be managed

You can use the following options to manage resources:

  • max_cursor_count

    Limits the number of cursors for a connection.

  • max_statement_count

    Limits the number of prepared statements for a connection.

  • priority

    Sets the priority level at which requests from a connection are executed.

  • max_priority

    Controls the maximum priority level for connections.