Sample Header Ad - 728x90

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

3 votes
2 answers
444 views
Link: https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15 > SQL Server: Memory Manager: Target Server Memory (KB) This counter > indicates an ideal amount of memory SQL Server could consume, based on > recent workload. Compare to Total Server Memory after a period of > typical operation to determine whether SQL Server has a desired amount > of memory allocated. I am getting conflicting definitions on the internet about the SQL Server: Memory Manager: Target Server Memory (KB) counter. MSDN doc definition is as shown in the above quote. Where as other online links say that this is the max server memory that we configure under the sql server options. Example: https://www.mssqltips.com/sqlservertip/6571/perfmon-counters-for-sql-server-memory/ > Target Server Memory (KB) is the amount of memory that SQL Server can > potentially allocate to the buffer pool under its current workload. > The Target Memory (KB) counter would reflect SQL Server "max server > memory (MB)" when it is set as that would be the amount of memory that > SQL Server could and would like to reach. Which definition is correct?
Asked by variable (3590 rep)
May 5, 2022, 12:31 PM
Last activity: May 6, 2022, 12:31 PM