lowlydba.sqlserver.rg_resource_pool (2.3.2) — module

Install collection

Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2

Add to requirements.yml

  collections:
    - name: lowlydba.sqlserver
      version: 2.3.2

Description

Creates or modifies a resource pool to be used by the Resource Governor. Default values are handled by the Powershell functions themselves.

Requirements

• L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Enable resource governor
  lowlydba.sqlserver.resource_governor:
    sql_instance: sql-01.myco.io
    enabled: true

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Create rg resource pool
  lowlydba.sqlserver.rg_resource_pool:
    sql_instance: sql-01.myco.io
    resource_pool: "rpLittle"
    max_cpu_perc: 5

Inputs

    
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

Outputs

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