Hi guys, I have a Windows 2008 Ent edition 64bit and SQL 2008 Ent 64 bit. Recently the performance is very sluggish. It has got 12gb of physical ram. I looked at the task manager. Memory usage is 97%. However when i look at the sqlservr.exe process, its only using 116,792K of ram. Why is the ram consume so little? This is the production server with high specs. I have a similar testing environment running on VM and it shows the correct amount of ram for sqlservr.exe process. Please advise.