• praneethydba (3/18/2014)


    HI,

    Its going high from 52% to 65,70,72 & today 80%...

    tomorrow it may reach 90 & finally 100%...

    You are truly not grasping this. Just because 100% of the memory is being used does not mean you have a problem. It just means that SQL Server is using the allocation of memory that you have said it is allowed to use. The LRU algorythm will take care of the rest....