• Thanks for reply

    I do have a question though.

    Server OS’s are x64, and even though I have set the value for LPIM with the service account, I have never seen a message in the SQL log stating “Using locked pages for buffer pool” on any of the servers. Did I miss something?

    I have noticed before enable LPIM in this box, In Task manger showing sqlservr.exe consuming 6.4 GB constantly and exceeds max memory setting. periviously I have setting max memory 5 GB, but sql server is not using max level. after that I have enabled LPIM and setting max memory 6114 MB.

    Performance Tap in task manager why 7.5 GB consuming physical memory using after restarted SQL services, it was totaly reduced and now comsuming 4.55 GB only...thats what I have mention first post memory leak sql 2k8 r2.

    OS level (Win 2008 R2 64 bit)there is no service pack installed, It is RTM. Does SP is require to be installed on OS side?

    thanks