With growing of sql server database size and increase in page views of website, you might run in to memory crunch situation. Please note:  You might run into memory crunch situation for number of reasons like memory leak in code, etc, but in this article we will be focusing on only one scenario that is restricting sql server memory usage. Cause of Memory crunch situation: By default if you