How to: Set Minimum Query Memory (SQL Server Management Studio)
Use the min memory per query option to specify the minimum amount of memory (in kilobytes) that will be allocated for the execution of a query. For example, if min memory per query is set to 2,048 kilobytes (KB), the query is guaranteed to get at least that much total memory. You can set min memory per query to any value from 512 through 2,147,483,647 KB (2 gigabytes (GB)). The default is 1,024 KB.