lowlydba / lowlydba.sqlserver / 2.3.2 / module / memory Sets the maximum memory for a SQL Server instance | "added in version" 0.1.0 of lowlydba.sqlserver" Authors: John McCall (@lowlydba)lowlydba.sqlserver.memory (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
Sets the maximum memory for a SQL Server instance.
- name: Automatically configure SQL max memory lowlydba.sqlserver.memory: sql_instance: sql-01.myco.io
- name: Manually configure SQL max memory lowlydba.sqlserver.memory: sql_instance: sql-01.myco.io max: 10240
max: default: 0 description: - The maximum memory in MB that the SQL Server instance can utilize. C(0) will automatically calculate the ideal value. 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
data: description: Output from the C(Set-DbaMaxMemory) function. returned: success, but not in check_mode. type: dict