Revisions to Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?

added 2 characters in body

Source Link

edited May 6, 2022 at 12:31

6k
5
37
68

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is "The ideal amount of memory the server is willing to consume (can be limited by "max server memory" setting)"

If Max Server Memory is set, then Target Server Memory = Max Server Memory

p.s. Running a procedure MemoryManagerInfoMemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is "The ideal amount of memory the server is willing to consume (can be limited by "max server memory" setting)"

If Max Server Memory is set, then Target Server Memory = Max Server Memory

p.s. Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is "The ideal amount of memory the server is willing to consume (can be limited by "max server memory" setting)"

If Max Server Memory is set, then Target Server Memory = Max Server Memory

p.s. Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

added 171 characters in body

Source Link

edited May 5, 2022 at 13:30

Aleksey Vitsko

6k
5
37
68

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is the max"The ideal amount of memory the server is willing to consume (can be limited by "max server memory" setting)"

If Max Server Memory is set, then Target Server Memory = Max Server Memory

p.s. Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is the max memory setting

Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is "The ideal amount of memory the server is willing to consume (can be limited by "max server memory" setting)"

If Max Server Memory is set, then Target Server Memory = Max Server Memory

p.s. Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Source Link

created May 5, 2022 at 13:14

Aleksey Vitsko

6k
5
37
68

Answering your question

Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting?

Target Server Memory is the max memory setting

Running a procedure MemoryManagerInfo, here what it shows on my server:

Target Server Memory = 184320 MB, and it corresponds to what I have in Max Server Memory in Server Settings

Stack Exchange Network

Return to Answer