The Configuration drilldown shows the various SQL Server configuration options, and allows you to make changes to most of these.
To see the Configuration drilldown
Click Monitor | Configuration.
|To investigate...||Look at the...|
|SQL Server configuration options||Configuration drilldown||
The SQL Server Configuration grid shows the SQL Server configuration options. You can change the value of any modifiable options displayed in the grid.
You must be a member of the Spotlight Diagnostic Administrators group to use the Change parameter option.
If some parameters are not displayed in the Configuration grid this is because the Show Advanced Options parameter is turned off. Spotlight does not turn this option on automatically as doing so clears the Procedure cache and Buffer cache. You can turn this option on by changing the parameter for Show Advanced Options from "0" to "1".
TIP: For general information on how to use Spotlight grids, see Spotlight grids
To change a modifiable option in the grid