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.