Summary information |
|
|---|---|
Default value |
100 |
Range of values |
1 – 2147483647 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration groups |
Memory Use, SQL Server Administration |
event buffers per engine specifies the number of event buffers available for each engine.
Events are used by Adaptive Server Monitor for observing Adaptive Server performance; if you are not using Adaptive Server Monitor, set this parameter to 1.
The value to which you set event buffers per engine depends on the number of engines in your configuration, the level of activity on your Adaptive Server, and the types of applications you are running.
Setting event buffers per engine to a low value may result in the loss of event information. The default value is likely to be too low for most sites. Values of 2000 and greater may be more reasonable for general monitoring. However, experiment to determine the appropriate value for your site.
In general, setting event buffers per engine to a high value may reduce the amount of performance degradation that Adaptive Server Monitor causes Adaptive Server.
Each event buffer uses 100 bytes of memory. To determine the total amount of memory used by a particular value for event buffers per engine, multiply the value by the number of Adaptive Server engines in your configuration.
