GilaMonster (1/5/2013)
SQLCrazyCertified (1/4/2013)
You mentioned that SQL using all of it's memory which is allocated to it is a normal behavior, if this is true, when does the SQL release the memory?When the OS signals that it's under memory pressure or when SQL shuts down.
I know it won't release the memory to OS, but when does SQL gets more memory to do other work/processes. Please advise.
Get more memory? If it's allocated up to max server memory then it won't allocate more.
So, if I understand you correctly, if SQL uses all the memory which is allocated to it, then SQL will not have enough memory to work on other outstanding processes, so, in this scenario can we say that memory is the issue for performance issues? If that's the case how can you say it's the normal expected behavior?
SueTons.
Regards,
SQLisAwe5oMe.