We have an enterprise version of SQL Server2008 . We have been seeing some memory usage issues lately. I was of the understanding that regardless of the amount of memory on a box (say its 10GB) that SQL Server would only use a certain percentage of physical memory. (Like up to 80% or in this case 8 GB) Perhaps this was with older versions of SQL Server, I'm not sure. I have done some reading and its rather confusing. Any clairification provided would be greatly appreciated.