I have one question about SQL Server memory usage.
When I start my SQL Server, it starts consuming memory and as the time goes (2-3 hours)
sqlservr.exe process consumes all the memory, leaving just 100 MB free for windows operations.
I have seen in the perfmon, the counter "SQL Server:Memory counter" shows only 5% of usage.
So why the
sqlservr.exe consumes all the memory even if it is using only 5% of it?
What I want to do is
sqlservr.exe to consume memory as per its need, not in advance. And I also don't want to put limit on "max server memory".
Thank you all