Server : LiteSpeed System : Linux barito.iixcp.rumahweb.net 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64 User : elvh3918 ( 1528) PHP Version : 8.2.31 Disable Function : mail Directory :  /usr/lib/python3.9/site-packages/ansible_collections/lowlydba/sqlserver/plugins/modules/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

# -*- coding: utf-8 -*-

# (c) 2022, John McCall (@lowlydba)
# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)

DOCUMENTATION = r'''
---
module: memory
short_description: Sets the maximum memory for a SQL Server instance
description:
  - Sets the maximum memory for a SQL Server instance.
version_added: 0.1.0
options:
  max:
    description:
      - The maximum memory in MB that the SQL Server instance can utilize. C(0) will automatically calculate the ideal value.
    type: int
    required: false
    default: 0
author: "John McCall (@lowlydba)"
requirements:
  - L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module
extends_documentation_fragment:
  - lowlydba.sqlserver.sql_credentials
  - lowlydba.sqlserver.attributes.check_mode
  - lowlydba.sqlserver.attributes.platform_all
'''

EXAMPLES = r'''
- 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
'''

RETURN = r'''
data:
  description: Output from the C(Set-DbaMaxMemory) function.
  returned: success, but not in check_mode.
  type: dict
'''