Summary information |
|
|---|---|
Default value |
40 |
Range of values |
40–2147483647 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
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 execute waitfor commands correctly. 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 is small. If you raise the number of alarms value significantly, you should adjust max memory accordingly.
