Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–2147483647 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System Administrator |
max SQL text monitored specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server Monitor.
Initially, the amount of memory allocated for saving text is 0, and since this parameter is static, you must restart Adaptive Server before you can start saving SQL Text.
If you do not allocate enough memory for the batch statements, the text you want to view may be in the section of the batch that is truncated. Sybase recommends an initial value of 1024 bytes of memory per user connection.
The total memory allocated from shared memory for the SQL text is the product of max SQL text monitored multiplied by the currently configured number of user connections.
For more information on max SQL text monitored, see “Configuring Adaptive Server to save SQL batch text”.
