Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

SQL Server | 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 from Monitored connections.
  2. Click Monitor | Configuration.

Show all

To investigate... Look at the...
SQL Server configuration options Configuration drilldown

TIP: For general information on how to use Spotlight grids, see Spotlight grids

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 Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating