This is an old post , but this is a problem I am facing now. I have few things what I am not able to configure.
I did read and understand that SQL is build up like this , but how come its behaving differently in different servers.
I have 20 server. There are SQL servers from 2000 to 2008R2. Why I have a problem with the memory in only 1 server? Why this memory problem is not other servers?
After lot of looking into the problem, we found that a few steps in a job is causing the memory increase. But this job was working fine till last thursday, and then suddenly on Friday this started giving a problem. No changes were made in the steps, neither any changes were made in the procedure executed in the steps.
I have decreased the max memory set , but still the problem is there.
What should we do that it does not use all the memory, or how to avoid memory increase.
We have already done 3 reboot of the server to reduce the memory problem.