Questions tagged [memory-manager]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
1answer
231 views

Why is my SQL Server giving out of memory errors when there should be plenty?

I have a production system running SQL Server 2019 Standard edition. It recently had a problem 3 times in 1 day where it became unresponsive until a reboot. Errors seem to point to memory limitations. ...
4
votes
0answers
253 views

SQL Server 2019: Memory performance with graph queries (possible memory leak)

I'm currently working on implementing an upgrade to SQL Server 2019 in order to make use of the graph features that are available in it. Our database stores records of files and their children, and ...
0
votes
1answer
204 views

SQL Server Stolen Server Memory - what it consists of?

Below what my server's performance counters show: Questions: 1) What "Stolen Server Memory" consists of ? I can assume "Plan Cache", "Lock Memory", "SQL Cache", "Connection", "Optimizer" are ...
1
vote
2answers
199 views

How to query SQL Server Memory Manager performance counters in DMV?

Is there any system catalog views or DMVs that can be used to query (in SSMS for example) below performance counters from SQL Server:Memory Manager ? Free Memory (KB) Target Server Memory Total ...