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.

To set minimum query memory

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Memory node.

  3. In the Minimum memory per query box, enter the minimum amount of memory (in kilobytes) that will be allocated for the execution of a query.

    The default value is 1024 KB per query.

See Also

Concepts