Hello. I am using SQL Server and I need some help. I want to find a parameter that indicates my memory usage but I dont know where to find it or how to calculate it. I know that SQL Server stores in memory cache recept processes that were executed, and if memory is full they are deleted to make room for others. I would like to know how many minutes are those processes keeped in cache. If duration is higher the server has enough memory, and if it is almost 0 (processes are keeped almost no time in cache) there is not enough memory. How can I find out this parameter? Can you please help me?
Need parameter for memory usage
March 27th, 2015 9:07am
Hello,
Seems you are looking for PLE = SQL Server Page Life Expectancy; the timespan while buffer pages (=Cache) is kept in Memory; see
SQL Server:Buffer Node
SQL Server Page Life Expectan
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 9:29am
Yes, that's what I want. Thank you very much!
March 27th, 2015 3:04pm
I know that SQL Server stores in memory cache recept processes that were executed, and if memory is full they are deleted to make room for others.
Hi,
I know you found the answer but I would like to correct you on above statement. You are correct about cache but when things are not required they are NOT DELETED as such. The pages which are holding data are moved back to disk so that space for new pages can be created. Lazywriter does this task often by using Lest Recently Used(LRU) algorithmFree Windows Admin Tool Kit Click here and download it now
March 28th, 2015 12:48am