Spotlight on SQL Server 9.5.2 - Getting Started Guide

Configuration Drilldown

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

1. Select a SQL Server connection from the Spotlight browser.

2. Click Monitor | Configuration.

   

Show all

To investigate...	Look at the...
SQL Server configuration options	Configuration drilldown	SQL Server Configuration grid The SQL ServerConfiguration grid shows the SQL Server configuration options. You can change the value of any modifiable options displayed in the grid. Tips: 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".

To change a modifiable option in the grid

1. Click the row in the grid corresponding to the option you want to change.
2. Enter a valid value for the chosen option in the Change parameter field. The Min and Max values in the Configuration grid specify the range of valid values.
3. Click the Submit button. Depending on the Modifiable value of the option you have chosen, the option value may change:
• Immediately, or
• When you restart SQL Server.

Related Topics

Spotlight on SQL Server Drilldowns (page 1)

About Spotlight Charts (page 1)

About Spotlight Grids (page 1)