Tip: Use resource governors

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 may want to 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.

SQL Anywhere provides a set of database options you can use to control resources. These options are called resource governors. These options can be set using the SET OPTION statement.

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.

Tip: Use resource governors

Resources that can be managed

See also