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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


max_priority option [database]

Controls the maximum priority level for connections.

Allowed values

Critical, High, Above Normal, Normal, Below normal, Low, Background




Can be set for an individual connection or for the PUBLIC group. Takes effect immediately. DBA authority required.

If you set this option temporarily, that setting applies to the current connection only. Different connections under the same user ID can have different settings for this option.


The scheduling of different priority levels allows all requests to get some CPU time, regardless of the priority level of the request. Higher priority requests get more time slices than lower priority ones.

See also