Depending on your use of Adaptive Server, you may need to adjust some parameters more frequently than others. You may find it is easier to work with a subset of parameters than having to see the entire group when you are working with only a few. You can set your display level to one of three values to give you the subset of parameters that best suits your working style.
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 to see more or fewer configuration parameters.
“Basic” shows just the most basic parameters. It is appropriate for very general server tuning.
“Intermediate” shows you parameters that are somewhat more complex, in addition to the “basic” parameters. This level is appropriate for a moderately complex level of server tuning.
“Comprehensive” shows you 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
The following is the syntax for setting your display level, where user_name is your Adaptive Server login name:
sp_displaylevel user_name [, basic | intermediate | comprehensive]
