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 |
number of alarms specifies the number of alarm structures allocated by Adaptive Server.
The Transact-SQL command waitfor defines a specific time, time interval, or event for the execution of a statement block, stored procedure, or transaction. Adaptive Server uses alarms to correctly execute waitfor commands. Other internal processes require alarms.
When Adaptive Server 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.
