info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



List SQL Server Non-Default Configuration Options
by BF (Principal Consultant; Architecture; Engineering)
2017-08-28









Using Management Studio, you can get a list of Non-Default Configuration settings that have been set for your SQL Server Instance.

In Management Studio, navigate to Object Explorer, right-click on the Instance name, select Report, select Server Dashboard.

Within this report, navigate to the section titled "Non Default Configuration Options".