The Configuration view allows you to view the SQL Server configuration settings for the selected SQL Server instance. When diagnosing problems with SQL Server performance it is helpful to see how it is configured. In addition, SQL Diagnostic Manager offers the ability to edit some configuration settings, depending on the option selected.
Access the Configuration view
You can open the Configuration view of the SQL Diagnostic Manager Overview tab by selecting the appropriate SQL Server instance, and clicking Overview > Configuration.
To edit a configuration setting:
- Select an option from the list.
- Click the Edit Value hyperlink in the Details pane.
- Enter the new value.
- Click OK.