lowlydba / lowlydba.sqlserver / 2.3.2 / module / rg_resource_pool Configures a resource pool for use by the Resource Governor | "added in version" 0.1.0 of lowlydba.sqlserver" Authors: John McCall (@lowlydba)lowlydba.sqlserver.rg_resource_pool (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
Creates or modifies a resource pool to be used by the Resource Governor. Default values are handled by the Powershell functions themselves.
- name: Enable resource governor lowlydba.sqlserver.resource_governor: sql_instance: sql-01.myco.io enabled: true
- name: Create rg resource pool lowlydba.sqlserver.rg_resource_pool: sql_instance: sql-01.myco.io resource_pool: "rpLittle" max_cpu_perc: 5
type: choices: - Internal - External default: Internal description: - Specify the type of resource pool. required: false type: str state: choices: - present - absent default: present description: - Whether or not the object should be C(present) or C(absent). required: false type: str cap_cpu_perc: description: - Cap CPU Percentage able to be used by queries in this resource pool. required: false type: int max_cpu_perc: description: - Maximum CPU Percentage able to be used by queries in this resource pool. required: false type: int max_mem_perc: description: - Maximum Memory Percentage able to be used by queries in this resource pool. required: false type: int min_cpu_perc: description: - Minimum CPU Percentage able to be used by queries in this resource pool. required: false type: int min_mem_perc: description: - Minimum Memory Percentage able to be used by queries in this resource pool. required: false type: int sql_instance: description: - The SQL Server instance to modify. required: true type: str sql_password: description: - Password for SQL Authentication. required: false type: str sql_username: description: - Username for SQL Authentication. required: false type: str resource_pool: description: - Name of the target resource pool. required: true type: str max_iops_per_vol: description: - Maximum IOPS/volume able to be used by queries in this resource pool. required: false type: int min_iops_per_vol: description: - Minimum IOPS/volume able to be used by queries in this resource pool. required: false type: int
data: description: Output from the C(Set-DbaRgResourcePool), C(New-DbaRgResourcePool), or C(Remove-DbaRgResourcePool) function. returned: success, but not in check_mode. type: dict