To avoid unnecesary performance penalities in sybase ase 15, you need to set the configuration parameter 'number of open partitions' high enough.

In Sybase ASE 15 each table and index consists of atleast one partition even when you don't use semantic data partitioning (optional licensed feature).

Sybase recommends using sp_countmetadata to estimate the required setting of this parameter and sp_monitorconfig to monitor its usage.


The default run value is 500. If this number is insufficient, Adaptive Server displays a message after trying to reuse active partition descriptors.

Error message

(Severity 17)(State 1)(Server PRODMARS_SYBASE)
Couldn't find an available partition descriptor. Raise the value of the configuration parameter 'number of open partitions' for more partition descriptors.

You must adjust this value.

Estimate number of open partitions setting for your sybase server
...