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....