Keith Tate (4/14/2014)
...Second if you want it to take 7GB of memory then set the "min server memory" and it will take that amount of memory.
...
Actually, the Min Memory setting is a 'floor' setting, in that SQL will only hold the minimum amount of memory once it has breached that minimum value - in your quote, Keith, 7GB. Until then, ie, until SQL actually takes up 7GB or more, SQL will only use the memory it needs, it does not initially grab all 7GB - see technet article.