sys.configurations
select name, value, value_in_use, minimum, maximum, is_dynamic, is_advanced, description from sys.configurations order by name;
### Column Details Column | Description ------------ | ------------------------------------------------------- name | Name of the configuration option. value | Configured value for this option. value_in_use | Running value currently in effect for this option. minimum | Minimum value for the configuration option. maximum | Maximum value for the configuration option. is_dynamic | 1 = The variable that takes effect when the RECONFIGURE statement is executed. is_advanced | 1 = The variable is displayed only when the show advancedoption is set. description | Description of the configuration option. ### Required Permission Requires membership in the `public` role.
sp_configure
RECONFIGURE
max degree of parallelism:
-- Enable advanced options to update advanced configurations EXEC sp_configure 'show advanced options', 1; RECONFIGURE; -- Update the 'max degree of parallelism' option EXEC sp_configure 'max degree of parallelism', 4; RECONFIGURE;