number of alarms

number of alarms specifies the number of alarm structures allocated by SAP ASE.

Summary Information

Default value

40

Range of values

40 – 2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Memory Use, SQL Server Administration

The Transact-SQL command waitfor defines a specific time, time interval, or event for the execution of a statement block, stored procedure, or transaction. SAP ASE uses alarms to correctly execute waitfor commands. Other internal processes require alarms.

When SAP ASE needs more alarms than are currently allocated, this message is written to the error log:
uasetalarm: no more alarms available

The number of bytes of memory required for each alarm structure is small. If you raise the number of alarms value significantly, adjust max memory accordingly.