max SQL text monitored specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server Monitor.
|
Summary Information |
|
|---|---|
|
Default value |
0 |
|
Range of values |
0–2147483647 |
|
Status |
Static |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration groups |
Memory Use, Monitoring |
If you do not allocate enough memory for the batch statements, the text you want to view may be truncated. SAP recommends that you use 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.