memoryclerk_sqlbufferpool KB

VM Reserved ...

My server Ram is 8GB, I set in sql server memory minimum memory is '0',and maximum memory is 6144mb, and I am not enable the AWE because I am running...

Actually nothing beyond running I reduce the memory size still problem going on I am not able to identifing the problem from last 5 hours the memory consumes 7.22 Gb,...

Thanks for your reply, but I am in still confusion if physical memory not releasing after execution of the query, here only one production server if I move to this...

But I set 6 GB for sql server it taking near about 7.6 gb, and no free memory available then how can I go to Live environment with this situation...

But when it not release the memory users get slow performance, recently I moved to live that time users said that very slow performance I thought because of Not releasing...

HI

I have a server with 8 Gb Ram I installed Sql server 2008 R2 on 64 bit platform Enterprise edition,in that for Sql server I allocated 6 GB of Ram...