http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Ususally databases engine try to allocate as much memory they can, unless some configuration sets an upper limit. This is how Sql Server or oracle database works, and it is perfectly good, because usually they run on a dedicated server. If you need to limit resource usage, just setup a limit. Having unused memory is not useful :).http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment8http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment8Thu, 05 Apr 2012 17:31:46 GMT@Itamar: In that case I would like to refer to the quote "Premature optimization..." You only know whether it costs more or less energy to cache data in memory instead of spinning up those platters every time until you actually measured it.http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment7http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment7Thu, 29 Mar 2012 12:57:25 GMTSomeone is probably going mention this soon anyway, so I thought I'll go ahead and do this myself. Often times, using less resources is considered "being green". For example this web CMS is written entirely in C++ to minimize the use of resources: http://cppcms.com/wikipp/en/page/rationale Question is how far you are willing to go with it. I'm pretty sure moving from your RDBMS of choice to any NoSQL that better fits your needs will save 10 times the energy you had been using so far...http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment6http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment6Thu, 29 Mar 2012 12:17:40 GMTMartin, We aren't trying to do blind guesses, we are going to use as much memory as we can, but we will stop if we reach the predefined limit. That means that if there are other apps running and using memory, it doesn't affect us, we aren't trying to use more memory, we are simply trying not to use too much.http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment5http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment5Thu, 29 Mar 2012 12:09:35 GMTHow did you take it into account?http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment4http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment4Thu, 29 Mar 2012 12:07:12 GMTPaul, did you notice that I linked to that exact article in the post?http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment3http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment3Thu, 29 Mar 2012 10:19:04 GMTPaul, I am well aware of this, and yes, we took that into account.http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment2http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment2Thu, 29 Mar 2012 10:18:03 GMTBe careful of this strategy of using the free memory to make decisions on memory allocation - http://blogs.msdn.com/b/oldnewthing/archive/2012/01/18/10257834.aspxhttp://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment1http://ayende.com/154625/if-you-throttle-me-any-me-i-am-going-to-throttle-you-back#comment1Thu, 29 Mar 2012 10:15:21 GMT