• Yes, I did set the max memory. Thank you very much for the clarification, George.

    SQL Server is using around 1.6 GB of memory and CACHESTORE_SQLCP uses almost 0.8GB. Do you think the ad-hoc plan chaching is causing the internal memory issue and alsocause low PLE. I have SQL Server 2005 SP1. Thanks