Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



List SQL Server Non-Default Configuration Options
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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".