CREATE RESOURCE POOL |
Crée un bassin de ressource |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
CREATE RESOURCE POOL pool_name [ 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 créer une bassin de ressource Resource Governor dans SQL Server.
Dernière mise à jour : Vendredi, le 19 Juin 2020