ALTER RESOURCE POOL |
Modifie le bassin de ressource |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
ALTER RESOURCE POOL { pool_name | "default" } [WITH ( [ MIN_CPU_PERCENT = value ] [ [ , ] MAX_CPU_PERCENT = value ] [ [ , ] CAP_CPU_PERCENT = value ] [ [ , ] AFFINITY { SCHEDULER = AUTO | ( scheduler_range_spec ) | NUMANODE = ( NUMA_node_range_spec ) }] [ [ , ] MIN_MEMORY_PERCENT = value ] [ [ , ] MAX_MEMORY_PERCENT = value ] [ [ , ] MIN_IOPS_PER_VOLUME = value ] [ [ , ] MAX_IOPS_PER_VOLUME = value ] )] [;] scheduler_range_spec ::= {SCHED_ID | SCHED_ID TO SCHED_ID}[,...n] NUMA_node_range_spec ::= {NUMA_node_ID | NUMA_node_ID TO NUMA_node_ID}[,...n] |
Description
Cette instruction permet de changer une configuration de bassin de ressource RESOURCE GOVERNOR dans le SQL Server.
Dernière mise à jour : Vendredi, le 19 Juin 2020