sys.configurations (Transact-SQL)sys.configurations (Transact-SQL)

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

系统中每个服务器范围的配置选项值各占一行。Contains a row for each server-wide configuration option value in the system.

列名Column name 数据类型Data type 描述Description
configuration_idconfiguration_id intint 配置值的唯一 ID。Unique ID for the configuration value.
namename nvarchar(35)nvarchar(35) 配置选项的名称。Name of the configuration option.
valuevalue sql_variantsql_variant 该选项的配置值。Configured value for this option.
最小值minimum sql_variantsql_variant 配置选项的最小值。Minimum value for the configuration option.
最大值maximum sql_variantsql_variant 配置选项的最大值。Maximum value for the configuration option.
value_in_usevalue_in_use sql_variantsql_variant 该选项当前使用的运行值。Running value currently in effect for this option.
descriptiondescription nvarchar(255)nvarchar(255) 配置选项的说明。Description of the configuration option.
is_dynamicis_dynamic bitbit 1 = 执行 RECONFIGURE 语句时生效的变量。1 = The variable that takes effect when the RECONFIGURE statement is executed.
is_advancedis_advanced bitbit 1 = 该变量显示时,才显示 advancedoption设置。1 = The variable is displayed only when the show advancedoption is set.

所有服务器配置选项的列表,请参阅服务器配置选项(SQL Server)For a list of all server configuration options, see Server Configuration Options (SQL Server).

备注

有关数据库级别配置选项,请参阅ALTER DATABASE SCOPED CONFIGURATION (TRANSACT-SQL)For database-level configuration options, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL). 若要配置软件 NUMA,请参阅SOFT-NUMA (SQL Server)To configure Soft-NUMA, see Soft-NUMA (SQL Server).

权限Permissions

要求 公共 角色具有成员身份。Requires membership in the public role. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

请参阅See Also

服务器范围的配置目录视图(Transact SQL) Server-wide Configuration Catalog Views (Transact-SQL)
目录视图 (Transact-SQL)Catalog Views (Transact-SQL)