Chapter 1: Overview

Adaptive Server configuration parameters

In Adaptive Server, you must set the parameters listed below.

To access the Database Object’s DDL text in Database Explorer and SQL Scanner:
```
"select on syscomments.txt", 1
```
To access the Estimated I/O Cost estimation in SQL Optimizer:
```
"allow resource limits", 1
```
To capture SQL statements with SQL Collector for Monitor Server:
```
"event buffers per engine", 2000
"max SQL text monitored", 4096
"enable monitoring", 0
```
The "enable monitoring", 0 setting is needed only when you are connected to Adaptive Server Enterprise 12.5.0.3.
To save abstract plans in the SQL Optimizer module and use the Abstract Plan Manager module:
```
"abstract plan cache", 0
"abstract plan replace", 0
```