Depending on how you use Adaptive Server, you may need to adjust some parameters more frequently than others. It may be easier to work with a subset of parameters.
The default display level is comprehensive. When you set your display level, the setting persists across multiple sessions. However, you can reset it at any time.
Basic – shows only the most basic parameters, and is appropriate for general server tuning.
Intermediate – includes parameters that are somewhat more complex, in addition to the basic parameters.
Comprehensive – includes all the parameters, including the most complex ones. This level is appropriate for users doing highly detailed server tuning.
The syntax for showing your current display level is:
sp_displaylevel
To set the display level, use the following, where user_name is your Adaptive Server login name:
sp_displaylevel user_name[, basic | intermediate | comprehensive]
