NOTE: The config_value in the result set of sp_configure is equivalent to the sys.configurations.value column. The run_value is equivalent to the sys.configurations.value_in_use column.
The following query can be used to determine if any configured values have not been installed:
select * from sys.configurations where value != value_in_use
There are two configuration options where the value and value_in_use may not be the same and this is expected behavior:
- "max server memory (MB)" - The default configured value of 0 will show up as value_in_use = 2147483647
- "min server memory (MB)" - The default configured value of 0 may show up as value_in_use = 8 (32bit) or 16 (64bit). In some cases, the value_in_use will be 0. In this situation, the "true" value_in_use is 8(32bit) or 16(64bit)
For a configuration option that is not dynamic there is no way to tell if the RECONFIGURE command has been run to perform the first step of installing the configuration change. Before you restart SQL Server to install a configuration change, run the RECONFIGURE command to ensure all configuration changes will take effect after a SQL Server restart.
Raksta ID: 2523164. Pēdējo reizi pārskatīts: 2011. gada 17. marts. Pārskatījums: 1