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

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 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 組態值的唯一識別碼。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.
minimumminimum sql_variantsql_variant 組態選項的最小值。Minimum value for the configuration option.
maximummaximum 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,請參閱NUMA (SQL Server)To configure Soft-NUMA, see Soft-NUMA (SQL Server).


需要 public 角色的成員資格。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)