Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am utterly confused. Just a month ago I went to a site where the site's SQL Server Database was eating up all the server memory. This is fine, and it was intended. This site was using SQL Server 2008 R2.

Then I went to another two sites which was using SQL Server 2008 R1 and SQL Server 2005, but there were still a lot of memory available.

They were both running the same application with almost similar Query load. In all three servers, the SQL Server's Maximum Memory option was set to max (2147483647) but the memory usage is clearly different.

Any hint on what's going on here?

share|improve this question
What do you mean by "clearly different" - can you provide specific numbers? And are your databases big enough, and have they had enough queries run through them, to actually fill the RAM? –  Shane Madden Aug 24 '12 at 4:34
Hi Thanks for the reply. Only SQL Server 2008R2 is consuming all the memory while the other servers are not utilizing RAM. And yes the database size are very big. All of them have about 100GB size –  user1034912 Aug 24 '12 at 5:02
Query caching, for one. –  nojak Aug 24 '12 at 7:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.