ALTER SERVER CONFIGURATION |
Modifie la configuration serveur |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
ALTER SERVER CONFIGURATION SET optionspec [;] optionspec ::= { process_affinity | diagnostic_log | failover_cluster_property | hadr_cluster_context | buffer_pool_extension | soft_numa | memory_optimized } process_affinity ::= PROCESS AFFINITY { CPU = { AUTO | CPU_range_spec } | NUMANODE = NUMA_node_range_spec } CPU_range_spec ::= { CPU_ID | CPU_ID TO CPU_ID } [ ,...n ] NUMA_node_range_spec ::= { NUMA_node_ID | NUMA_node_ID TO NUMA_node_ID } [ ,...n ] diagnostic_log ::= DIAGNOSTICS LOG { ON | OFF | PATH = { 'os_file_path' | DEFAULT } | MAX_SIZE = { 'log_max_size' MB | DEFAULT } | MAX_FILES = { 'max_file_count' | DEFAULT } } failover_cluster_property ::= FAILOVER CLUSTER PROPERTY resource_property resource_property ::= { VerboseLogging = { 'logging_detail' | DEFAULT } | SqlDumperDumpFlags = { 'dump_file_type' | DEFAULT } | SqlDumperDumpPath = { 'os_file_path'| DEFAULT } | SqlDumperDumpTimeOut = { 'dump_time-out' | DEFAULT } | FailureConditionLevel = { 'failure_condition_level' | DEFAULT } | HealthCheckTimeout = { 'health_check_time-out' | DEFAULT } } hadr_cluster_context ::= HADR CLUSTER CONTEXT = { 'remote_windows_cluster' | LOCAL } buffer_pool_extension::= BUFFER POOL EXTENSION { ON ( FILENAME = 'os_file_path_and_name' , SIZE = size_spec ) | OFF } size_spec ::= { size [ KB | MB | GB ] } soft_numa ::= SOFTNUMA { ON | OFF } memory-optimized ::= MEMORY_OPTIMIZED { ON | OFF | [ TEMPDB_METADATA = { ON [(RESOURCE_POOL='resource_pool_name')] | OFF } | [ HYBRID_BUFFER_POOL = { ON | OFF } } |
Description
Cette instruction permet de modifier un ajustement de configuration pour le serveur courant dans SQL Server.
Dernière mise à jour : Vendredi, le 19 Juin 2020